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 f0afbb9b0903030952k5bd08302o2cd71cd195f2ea79@mail.gmail.com
Whole thread Raw
In response to Re: Postgres 8.3, four times slower queries?  (david@lang.hm)
List pgsql-performance
Tree view
On Tue, Mar 3, 2009 at 12:38 PM, <david@lang.hm> wrote:
if you haven't done a vaccum analyse on either installation then postgres' idea of what sort of data is in the database is unpredictable, and as a result it's not surprising that the two systems guess differently about what sort of plan is going to be most efficiant.

try doing vaccum analyse on both databases and see what the results are.

David Lang

These are the results with vacuum analyze:
8.2.12: 624.366 ms
8.3.3: 1273.601 ms
Attachment

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Problems with ordering (can't force query planner to use an index)
Next
From: Sebastjan Trepca
Date:
Subject: Re: Problems with ordering (can't force query planner to use an index)