Re: maintenance_work_mem and autovacuum - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: maintenance_work_mem and autovacuum
Date
Msg-id 49CC0D6E.2030407@agliodbs.com
Whole thread Raw
In response to Re: maintenance_work_mem and autovacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 3/26/09 4:10 PM, Tom Lane wrote:
> Simon Riggs<simon@2ndQuadrant.com>  writes:
>> On Thu, 2009-03-26 at 13:43 -0700, Josh Berkus wrote:
>>> That said, it would be unnecessary if I could use ROLES to set
>>> parameters more reliably ....
>
>> Hmmm, perhaps the right way to do this is to have a user called
>> "autovacuum" that is used to perform autovacuums.
>
> Interesting idea, but maybe we should wait on it until we see what
> (if any) changes we are going to put into the relationship between
> roles and parameters.  Josh seems not to be happy with that ...

Well, it would work at present for this, because it's a login role, 
presumably.

--Josh



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: maintenance_work_mem and autovacuum
Next
From: Bernd Helmle
Date:
Subject: Error message and infinite date and timestamp conversion in XML