On 11/24/20 8:36 AM, David Gauthier wrote:
Hi:
11.3 on linux
I've come up with a plan to archive data from my main DB which involves
creating other DBs on the same server. But even though there will be zero
activity on the archive DBs in terms of insert/update/delete, and almost
no activity in terms of select, I'm still worried that the mere existence
of these other DBs will steal resources away from the instance and degrade
performance in my main DB.
*Why?* If the data is just sitting there like a dead lump, it's not using
any RAM or CPU cycles... And if you're afraid of autovacuum and autoanalyze
stealing resources, then disable them (at the table level).
--
Angular momentum makes the world go 'round.