unanalyze a foreign table
Jeff Janes <[email protected]> Sun, 22 Dec 2019 14:21:32 -0500
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <CAMkU=1x0C6H-yUPimAb-kzO1FqNeHW06gNT7Dny2SY3Ua23j4Q@mail.gmail.com> |
I did a manual ANALYZE of a foreign table, to see if it would make a troublesome query better. It did, but it also made some other queries that were previously fine to become far worse. Is there a way to undo the analyze? I can muck around in the catalogs like below, but seems really grotty. delete from pg_statistic where starelid=418911; The other option seems to be doing a `drop foreign table ... cascade`, but then recreating all the cascaded drops is quite annoying and error prone. I currently solved it by re-cloning my performance testing server from upstream, but that also is not very convenient. Is directly manipulating the catalogs really the best way? Cheers, Jeff