Re: Performance hit if I create multiple DBs on same instance

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Performance hit if I create multiple DBs on same instance
Date: 2020-11-25 15:54:47
Message-ID: e9b556a7-e05d-277b-0e62-87472e2c0f29@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-11-25 16:06:33 Re: INSERT Trigger to check for existing records : Does this do what I hope it is doing?
Previous Message Hagen Finley 2020-11-25 15:41:07 Re: INSERT Trigger to check for existing records : Does this do what I hope it is doing?