Re: Performance hit if I create multiple DBs on same instance

Ron <ronljohnsonjr@xxxxxxxxx> · Tue, 24 Nov 2020 11:34:42 -0600



    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.