Re: Disable autovacuum guc? - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Disable autovacuum guc?
Date
Msg-id 9e322825-54b2-bbe1-e0fa-a0d44255d392@commandprompt.com
Whole thread Raw
In response to Re: Disable autovacuum guc?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On 10/20/2016 08:54 AM, Josh Berkus wrote:
> On 10/20/2016 06:34 AM, Joshua D. Drake wrote:
>> On 10/19/2016 07:22 PM, Josh Berkus wrote:
>>> On 10/19/2016 06:27 PM, Joshua D. Drake wrote:

>> Hrm, true although that is by far a minority of our users. What if we
>> made it so we disabled the autovacuum guc but made it so you could
>> disable autovacuum per database (ALTER DATABASE SET or something such
>> thing?).
>
> Well, that wouldn't fix the problem; people would just disable it per
> database, even if it was a bad idea.

I doubt this very much. It requires a different level of sophistication.

General users (not you, not me, and certainly not Haas or Lane) don't 
run anything but an application backed to an ORM. They understand a conf 
file but they aren't going to touch anything they consider
"underneath".

Sincerely,

JD

-- 
Command Prompt, Inc.                  http://the.postgres.company/                        +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Disable autovacuum guc?
Next
From: Stephen Frost
Date:
Subject: Re: Renaming of pg_xlog and pg_clog