From: | David Gauthier <davegauthierpg(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | 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:33:46 |
Message-ID: | CAMBRECBozxP2qRhn5a4hfLV6K_zma1uQNyrA81oVaLfi1fs74g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ok, thanks.
I was also planning on manually running vacuum, reindex and analyze on the
main DB after removing the data from the main DB after archiving. Does
that sound necessary and reasonable ?
On Tue, Nov 24, 2020 at 10:15 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> 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 | Bruce Momjian | 2020-11-24 15:47:22 | Re: Performance hit if I create multiple DBs on same instance |
Previous Message | Adrian Klaver | 2020-11-24 15:15:30 | Re: Performance hit if I create multiple DBs on same instance |