Re: Postgres 8.3, four times slower queries?

From: Aaron Guyon <battlemage(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres 8.3, four times slower queries?
Date: 2009-03-05 19:58:09
Message-ID: f0afbb9b0903051158s3e0a9f69re04077f8f43b5ec3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Mar 5, 2009 at 12:58 PM, Joshua D. Drake <jd(at)commandprompt(dot)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 Content-Type Size
new_tuple1.txt text/plain 6.1 KB

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jonathan Hseu 2009-03-06 01:42:19 Re: Index scan plan estimates way off.
Previous Message Robert Haas 2009-03-05 19:15:27 Re: Postgres 8.3, four times slower queries?