Re: Autovacuum on sys tables

2022-12-19 Thread Thomas Boussekey
Hi, Le lun. 19 déc. 2022 à 07:12, Inzamam Shafiq a écrit : > Thanks Thomas for the response, > > It means if I run VACUUM ANALYZE on pg_attribute or pg_class table, it is > completely safe? Can you please also please confirm what is meant by > "mid-level" vacuum? > To clarify my last message, V

Selecting across servers

2022-12-19 Thread Brad White
I needed to be able to compare the contents of a table across several databases and clusters. Since it took me several hours to write this, I thought I'd share it with you, in case anyone needs a starting point for anything similar. BACKGROUND DETAILS: These databases are all on sandbox servers,