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

From Дмитрий Шалашов
Subject Re: Server vacuuming the same table again and again
Date
Msg-id CAKPeCUGtqSyVdYbD6iuA2YRbyRo=cDo7Y7ZzKN+ABVyn=Q+p1A@mail.gmail.com
Whole thread Raw
In response to Re: Server vacuuming the same table again and again  (Torsten Förtsch <torsten.foertsch@gmx.net>)
List pgsql-performance
Turns out yesterday we fixed a bug and introduced a new bug, which was previously hidden by yet another bug which in turn we had fixed last week... %)
In result last fix led to greatly increased number of requests to the database.

But still, thanks for that, we found out about too frequent checkpoints and that our recommendations table has three times more dead tuples than live ones.

We will fix our autovacuum configuration.

As for other problem - 100% cpu load with idle disks - it is no more reproducing and we don't want it to :)

Thanks Ilya and Torsten!


Best regards,
Dmitriy Shalashov


2014-04-25 13:47 GMT+04:00 Torsten Förtsch <torsten.foertsch@gmx.net>:
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: Torsten Förtsch
Date:
Subject: Re: Server vacuuming the same table again and again
Next
From: Tom Lane
Date:
Subject: Re: Poor performance for delete query