Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance hit if I create multiple DBs on same instance - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Performance hit if I create multiple DBs on same instance
Date
Msg-id 20201125170929.GB26301@momjian.us
Whole thread Raw
In response to Re: Performance hit if I create multiple DBs on same instance  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view 
On Wed, Nov 25, 2020 at 03:59:06PM +0100, Laurenz Albe wrote:
> On Tue, 2020-11-24 at 11:34 -0600, Ron wrote:
> > And if you're afraid of autovacuum and autoanalyze stealing resources, then disable them (at the table level).
> 
> Ugh, bad advice.
> 
> Better would be to VACUUM (FREEZE) these static table once, then autovacuum
> won't ever perform resource consuming activities on them again.

Yes, also, even if you never do that, autovacuum will eventually freeze
those tables and never access them again.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee

pgsql-general by date:

Previous
From: Mats Julian Olsen
Date:
Subject: Re: postgres_fdw insert extremely slow
Next
From: Tom Lane
Date:
Subject: Re: postgres_fdw insert extremely slow