Re: Server vacuuming the same table again and again

From: Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net>
To: Дмитрий Шалашов <skaurus(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Server vacuuming the same table again and again
Date: 2014-04-25 09:47:08
Message-ID: 535A2F1C.2060107@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 25/04/14 09:47, Дмитрий Шалашов wrote:
> Half a day ago one of our production PG servers (arguably busiest one)
> become very slow; I went to investigate the issue and found that it runs
> simultaneously '(auto)VACUUM ANALYZE recommendations' - largest table on
> that server - and checkpoint, giving a 100% disk load

Maybe the table has reached the state where it needs a VACUUM FREEZE.
Autovacuum does that for you but it requires a complete scan of the table.

Torsten

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Дмитрий Шалашов 2014-04-25 10:36:18 Re: Server vacuuming the same table again and again
Previous Message Ilya Kosmodemiansky 2014-04-25 09:46:30 Re: Server vacuuming the same table again and again