Re: optimizing Postgres queries

From: David Teran <david(dot)teran(at)cluster9(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: optimizing Postgres queries
Date: 2004-01-05 19:57:47
Message-ID: 6F2414E8-3FB9-11D8-A528-000A95A6F0DC@cluster9.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-performance by date

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