From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | David Gauthier <davegauthierpg(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Performance hit if I create multiple DBs on same instance |
Date: | 2020-11-24 15:15:30 |
Message-ID: | 798cfe15-c32d-9aa6-9108-ef54f06c5156@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/24/20 6: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. So my question is whether or not
> that worry is valid or not.
The primary resource I see they taking is storage. If you have adequate
space so that the primary and archive databases can grow into it then I
don't see a problem on that score. There will also be some additional
overhead for the automatic VACUUM and ANALYZE operations. Since the
archive databases are quiescent that will be on the order of monitoring
not really processing.
>
> Thanks in Advance for any help !
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | David Gauthier | 2020-11-24 15:33:46 | Re: Performance hit if I create multiple DBs on same instance |
Previous Message | David G. Johnston | 2020-11-24 15:13:11 | Re: Performance hit if I create multiple DBs on same instance |