Re: Postgres 8.3, four times slower queries?

From: Kevin Grittner
Subject: Re: Postgres 8.3, four times slower queries?
Date: ,
Msg-id: 49AFCC30.EE98.0025.0@wicourts.gov
(view: Whole thread, Raw)
In response to: Re: Postgres 8.3, four times slower queries?  (Aaron Guyon)
Responses: Re: Postgres 8.3, four times slower queries?  (Robert Haas)
List: pgsql-performance

Tree view

Postgres 8.3, four times slower queries?  (Aaron Guyon, )
 Re: Postgres 8.3, four times slower queries?  (Tom Lane, )
  Re: Postgres 8.3, four times slower queries?  (Aaron Guyon, )
   Re: Postgres 8.3, four times slower queries?  (, )
    Re: Postgres 8.3, four times slower queries?  (Aaron Guyon, )
   Re: Postgres 8.3, four times slower queries?  (Tom Lane, )
    Re: Postgres 8.3, four times slower queries?  (Aaron Guyon, )
     Re: Postgres 8.3, four times slower queries?  (Aaron Guyon, )
     Re: Postgres 8.3, four times slower queries?  (Aaron Guyon, )
      Re: Postgres 8.3, four times slower queries?  (Aaron Guyon, )
       Re: Postgres 8.3, four times slower queries?  ("Kevin Grittner", )
        Re: Postgres 8.3, four times slower queries?  (Robert Haas, )
     Re: Postgres 8.3, four times slower queries?  (Robert Haas, )
 Re: Postgres 8.3, four times slower queries?  (Robert Haas, )
 Re: Postgres 8.3, four times slower queries?  (Aaron Guyon, )
 Re: Postgres 8.3, four times slower queries?  (Aaron Guyon, )

>>> Aaron Guyon <> 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:

From: Aaron Guyon
Date:
Subject: Re: Postgres 8.3, four times slower queries?
From: Jonathan Hseu
Date:
Subject: Re: Index scan plan estimates way off.