Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron
Subject Re: Performance hit if I create multiple DBs on same instance
Date
Msg-id e9b556a7-e05d-277b-0e62-87472e2c0f29@gmail.com
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 11/25/20 8:59 AM, 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.

Good to know.

-- 
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Hagen Finley
Date:
Subject: Re: INSERT Trigger to check for existing records : Does this do what I hope it is doing?
Next
From: Adrian Klaver
Date:
Subject: Re: INSERT Trigger to check for existing records : Does this do what I hope it is doing?