Re: maintenance_work_mem and autovacuum

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