Re: maintenance_work_mem and autovacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: maintenance_work_mem and autovacuum
Date: 2009-03-26 23:10:23
Message-ID: 28626.1238109023@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs <simon(at)2ndQuadrant(dot)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 ...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2009-03-26 23:19:10 Re: maintenance_work_mem and autovacuum
Previous Message Tom Lane 2009-03-26 22:51:36 Re: Review: B-Tree emulation for GIN