[PERFORM] simple left join slows query more than expected

I'v spent a couple days playing with this problem and searching the mailing lists and docs etc but come up with nothing. Any help would be much appreciated. Setup is postgres 7.3.2 on redhat 7.1 on a 1.3GHz Athlon machine with 1G pc133 ram and SCSI. Here is the same query with the addition of a l

Re: [PERFORM] For full text indexing, which is better, tsearch2 or

Any thoughts? Actually, I ran my tests using tsearch V1. I wonder if there has been some weird regression between tsearch 1 and 2? I also ran my tests on 7.3.4 :( Chris ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [PERFORM] For full text indexing, which is better, tsearch2 or

On Wed, Nov 26, 2003 at 09:12:30PM -0800, Steve Atkins wrote: > On Thu, Nov 27, 2003 at 12:41:59PM +0800, Christopher Kings-Lynne wrote: > > >Does anyone have any metrics on how fast tsearch2 actually is? > > > > > >I tried it on a synthetic dataset of a million documents of a hundred > > >words ea

Re: [PERFORM] For full text indexing, which is better, tsearch2 or

Any thoughts? Actually, I ran my tests using tsearch V1. I wonder if there has been some weird regression between tsearch 1 and 2? hris ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PERFORM] Impossibly slow DELETEs

I did not conduct much more test but from what I've seen, it looks like the ODBC driver is in the doldrums, not PG. For example, when I run my software on Windows rather than Linux, everything just works as expected. Sorry for disturbing. And btw, I use ODBC because my target DB is Oracle and I

Re: [PERFORM] very large db performance question

Hi, I have done some performance tests on 1Gb and 4 Gb Databases on a mono Pentium 4 , 1 Gb RAM, IDE disk, SCSI disks and RAID0 LUN on DAS 5300 on Linux RedHat 7.3. In each cases my tests make select, update and insert. One of them is pgbench. You can find it in Postgres/contrib/pgbench. The othe