Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurenz Albe
Subject Re: Performance hit if I create multiple DBs on same instance
Date
Msg-id 79e102bcb98a7af48924f427512a502108408b5d.camel@cybertec.at
Whole thread Raw
In response to Re: Performance hit if I create multiple DBs on same instance  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Performance hit if I create multiple DBs on same instance  (Ron <ronljohnsonjr@gmail.com>)
Re: Performance hit if I create multiple DBs on same instance  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Tree view 
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.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216
Next
From: Hagen Finley
Date:
Subject: Re: INSERT Trigger to check for existing records : Does this do what I hope it is doing?