Re: Configure Different Databases on One Server

From: Jim Longwill <JLongwill(at)psmfc(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Configure Different Databases on One Server
Date: 2015-10-29 19:41:03
Message-ID: 5632764F.4040908@psmfc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok,
Thanks! I think the ALTER DATABASE.. commands will work well for what
I'm doing now. I want to experiment with one database (doing manual
vacuuming, etc.) while leaving the other databases undisturbed.
Regards,
--Jim Longwill

On 10/29/2015 12:36 PM, John R Pierce wrote:
> On 10/29/2015 12:14 PM, Tom Lane wrote:
>> Might be better to settle for configuring specific large tables using
>> per-table vacuum settings, and not sweat the small stuff at a per-DB
>> level.
>
> indeed, since you ALSO need to vacuum the system tables occasionally,
> or things go pear-shaped if you do lots of DDL.
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Florin Andrei 2015-10-29 19:41:09 bdr-plugin packages repo not updated to 0.9.3?
Previous Message John R Pierce 2015-10-29 19:36:54 Re: Configure Different Databases on One Server