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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Performance hit if I create multiple DBs on same instance
Date: 2020-11-25 14:59:06
Message-ID: 79e102bcb98a7af48924f427512a502108408b5d.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next 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?
Previous Message Magnus Hagander 2020-11-25 10:35:34 Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216