Re: Strange performance degradation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lorenzo Allegrucci <lorenzo(dot)allegrucci(at)forinicom(dot)it>
Cc: pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Strange performance degradation
Date: 2009-11-20 14:49:59
Message-ID: 21498.1258728599@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Lorenzo Allegrucci <lorenzo(dot)allegrucci(at)forinicom(dot)it> writes:
> So, my main question is.. how can just a plain simple restart of postgres
> restore the original performance (3% cpu time)?

Are you killing off any long-running transactions when you restart?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ray Stell 2009-11-20 15:03:04 Re: index storage planning
Previous Message Brian Modra 2009-11-20 14:06:37 Re: Strange performance degradation

Browse pgsql-performance by date

  From Date Subject
Next Message Jonathan Foy 2009-11-20 15:01:35 Re: View based upon function won't use index on joins
Previous Message Brian Modra 2009-11-20 14:06:37 Re: Strange performance degradation