Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 8.3, four times slower queries? - Mailing list pgsql-performance

From Aaron Guyon
Subject Re: Postgres 8.3, four times slower queries?
Date
Msg-id f0afbb9b0903051158s3e0a9f69re04077f8f43b5ec3@mail.gmail.com
Whole thread Raw
In response to Postgres 8.3, four times slower queries?  (Aaron Guyon <battlemage@gmail.com>)
List pgsql-performance
Tree view
On Thu, Mar 5, 2009 at 12:58 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
What happens if you do this:

SET cpu_tuple_cost TO '0.5';
SET cpu_index_tuple_cost TO '0.5';
EXPLAIN ANALYZE 8.3 query....

Right now, I'm getting very good results with the above.  I'm still running additional tests but I'll keep you guys updated. I've attached the new explain analyze.
Attachment

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Postgres 8.3, four times slower queries?
Next
From: Jonathan Hseu
Date:
Subject: Re: Index scan plan estimates way off.