Postgres Pro
Downloads
Home   >   mailing lists

Re: Server vacuuming the same table again and again - Mailing list pgsql-performance

From Torsten Förtsch
Subject Re: Server vacuuming the same table again and again
Date
Msg-id 535A2F1C.2060107@gmx.net
Whole thread Raw
In response to Server vacuuming the same table again and again  (Дмитрий Шалашов <skaurus@gmail.com>)
Responses Re: Server vacuuming the same table again and again  (Дмитрий Шалашов <skaurus@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Ilya Kosmodemiansky
Date:
Subject: Re: Server vacuuming the same table again and again
Next
From: Дмитрий Шалашов
Date:
Subject: Re: Server vacuuming the same table again and again