Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.2 -> 7.4: horrible performance hit! - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.2 -> 7.4: horrible performance hit!
Date
Msg-id 26900.1121205371@sss.pgh.pa.us
Whole thread Raw
In response to 7.2 -> 7.4: horrible performance hit!  (Marco Gaiarin <gaio@sv.lnf.it>)
List pgsql-general
Tree view 
Marco Gaiarin <gaio@sv.lnf.it> writes:
> The application work well, apart some query that took some *MINUTES* to
> complete, when on 7.2 take (half of) second(s).

Could we see EXPLAIN ANALYZE results for the problem query on both
versions?

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Checkpoints are occurring too frequently...
Next
From: Tom Lane
Date:
Subject: Re: getting the ranks out of items with SHARED