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

Re: Strange performance degradation

From: Lorenzo Allegrucci <lorenzo(dot)allegrucci(at)forinicom(dot)it>
To: pgsql-performance(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange performance degradation
Date: 2009-11-20 20:26:10
Message-ID: 4B06FB62.7080907@forinicom.it (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
Brian Modra wrote:
> I had a similar problem: I did a large delete, and then a selct which
> "covered" the previous rows.
> It took ages, because the index still had those deleted rows.
> Possibly the same happens with update.
> 
> Try this:
> vacuum analyse
> reindex database ....
> (your database name instead of ...)
> 
> or, rather do this table by table:
> vacuum analyse ....
> reindex table ...
> 
> 
> Autovacuum is a generally good thing.
> 
>> So, my main question is.. how can just a plain simple restart of postgres
>> restore the original performance (3% cpu time)?
> 
> there were probably some long transactions running. Stopping postgres
> effectively kills them off.

I'll try that, thanks for your help Brian.

In response to

pgsql-performance by date

Next:From: Thom BrownDate: 2009-11-20 20:35:58
Subject: Re: Postgres query completion status?
Previous:From: Lorenzo AllegrucciDate: 2009-11-20 20:24:38
Subject: Re: Strange performance degradation

pgsql-general by date

Next:From: akp geekDate: 2009-11-20 20:38:14
Subject: PG_STANDBY ISSUE
Previous:From: Lorenzo AllegrucciDate: 2009-11-20 20:24:38
Subject: Re: Strange performance degradation

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