Re: 7.2 -> 7.4: horrible performance hit!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marco Gaiarin <gaio(at)sv(dot)lnf(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.2 -> 7.4: horrible performance hit!
Date: 2005-07-12 21:56:11
Message-ID: 26900.1121205371@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marco Gaiarin <gaio(at)sv(dot)lnf(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-07-12 22:03:03 Re: getting the ranks out of items with SHARED
Previous Message Joshua D. Drake 2005-07-12 21:46:35 Re: Checkpoints are occurring too frequently...