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