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.