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

From Kevin Grittner
Subject Re: Postgres 8.3, four times slower queries?
Date
Msg-id 49AFCC30.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: Postgres 8.3, four times slower queries?  (Aaron Guyon <battlemage@gmail.com>)
Responses Re: Postgres 8.3, four times slower queries?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
>>> Aaron Guyon <battlemage@gmail.com> wrote:
> 8.3.3: 1195 ms
> 8.2.12: 611 ms

Could you send the non-commented lines from the postgresql.conf files
from both installations?

If feasible, update to the latest bug-fix version of 8.3.

Also, if you haven't already done so, try setting effective_cache_size
= '3GB' and random_page_cost = 2 for the 8.3 database and restart to
see what kind of plan you get.

-Kevin

pgsql-performance by date:

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