Postgres Pro
Downloads
Home   >   mailing lists

Re: optimizing Postgres queries - Mailing list pgsql-performance

From David Teran
Subject Re: optimizing Postgres queries
Date
Msg-id 6F2414E8-3FB9-11D8-A528-000A95A6F0DC@cluster9.com
Whole thread Raw
In response to optimizing Postgres queries  (David Teran <david.teran@cluster9.com>)
Responses Re: optimizing Postgres queries
List pgsql-performance
Tree view 
... wow:

executing a batch file with about 4250 selects, including lots of joins
other things PostgreSQL 7.4 is about 2 times faster than FrontBase
3.6.27. OK, we will start to make larger tests but this is quite
interesting already: we did not optimize a lot, just invoked VACUUM
ANALYZE and then the selects ;-)

Thanks to all who answered to this thread.

cheers David

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: failures on machines using jfs
Next
From: CoL
Date:
Subject: Re: Select max(foo) and select count(*) optimization