Re: slow full table update

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: slow full table update
Дата
Msg-id dcc563d10811121458t63499067ucd50e287d5c24a0@mail.gmail.com
обсуждение исходный текст
Ответ на Re: slow full table update  (<firerox@centrum.cz>)
Ответы Re: slow full table update
Список pgsql-performance
This is the critical point.  You have this line:

There were 132969 unused item pointers.

Which says there's 132k or so dead rows in your table.  Which means
vacuum / autovacuum isn't keeping up.  Did you try and stop the update
several times?  Each time it starts then gets killed it creates dead
rows.

Try doing a vacuum full followed by a reindex OR a cluster on this
table and see if that helps.

В списке pgsql-performance по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: slow full table update
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Disk usage question