Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-performance by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group