Re: Temporarily very slow planning time after a big delete

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Temporarily very slow planning time after a big delete
Дата
Msg-id CAKJS1f_XKnknLkv5s2cYxpoJ8KAJf0aL2ELK3uYTsiZ2VcNTZg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Temporarily very slow planning time after a big delete  (Walter Smith <walter@carezone.com>)
Ответы Re: Temporarily very slow planning time after a big delete
Список pgsql-performance
On Tue, 21 May 2019 at 14:04, Walter Smith <walter@carezone.com> wrote:
> I'm so sorry -- I meant to give the version, of course. It's 9.6.13.

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=3ca930fc3
has been applied since then.

It would be good if you could confirm the problem is resolved after a
vacuum.  Maybe run VACUUM VERBOSE on the table and double check
there's not some large amount of tuples that are "nonremovable".

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Walter Smith
Дата:
Сообщение: Re: Temporarily very slow planning time after a big delete
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: Re: Trying to handle db corruption 9.6