Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group