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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
