Performance hit if I create multiple DBs on same instance

From: David Gauthier <davegauthierpg(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Performance hit if I create multiple DBs on same instance
Date: 2020-11-24 14:36:34
Message-ID: CAMBRECBzwQ+7FhuO61Zd2dQRxcXFpijdR2=eyfNPfUpO4K6XaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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. So my question is whether or not that worry is
valid or not.

Thanks in Advance for any help !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-11-24 15:13:11 Re: Performance hit if I create multiple DBs on same instance
Previous Message Michael Lewis 2020-11-24 04:05:06 Re: ERROR : invalid transaction termination : PostgreSQL v12