Re: maintenance_work_mem and autovacuum

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: 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 21:29:06
Message-ID: 49CBF3A2.1090206@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon,

> Hmmm, perhaps the right way to do this is to have a user called
> "autovacuum" that is used to perform autovacuums.

This makes sense, depending on which autovac params actually get picked
up from the session.

> Seems like a nice small change for 8.4?

Hmmm. Maybe not small enough.

--Josh

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bernd Helmle 2009-03-26 21:29:16 Re: maintenance_work_mem and autovacuum
Previous Message Simon Riggs 2009-03-26 21:23:48 Re: maintenance_work_mem and autovacuum