Horton

Re: optimizing Postgres queries

David Teran <david.teran@cluster9.com>

View thread View on postgr.es
From: David Teran <david.teran@cluster9.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Date: 2004-01-05T19:57:47Z
Lists: pgsql-performance 
... 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