Re: Temporarily very slow planning time after a big delete
David Rowley <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CAKJS1f_XKnknLkv5s2cYxpoJ8KAJf0aL2ELK3uYTsiZ2VcNTZg@mail.gmail.com> |
On Tue, 21 May 2019 at 14:04, Walter Smith <[email protected]> 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