... 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

In response to

• Re: optimizing Postgres queries at 2004-01-05 19:23:45 from Tom Lane

Responses

• Re: optimizing Postgres queries at 2004-01-09 03:16:49 from Rod Taylor

pgsql-performance by date

Next:	From: John Siracusa	Date: 2004-01-05 20:01:18
	Subject: Re: Select max(foo) and select count(*) optimization
Previous:	From: Rod Taylor	Date: 2004-01-05 19:52:06
	Subject: Re: Select max(foo) and select count(*) optimization