Re: Displaying accumulated autovacuum cost

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, Euler Taveira de Oliveira <euler(at)timbira(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Displaying accumulated autovacuum cost
Date: 2011-08-18 13:57:36
Message-ID: 4731.1313675856@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Magnus Hagander <magnus(at)hagander(dot)net> writes:
> On Thu, Aug 18, 2011 at 03:23, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
>> On 08/17/2011 07:42 PM, Euler Taveira de Oliveira wrote:
>>> I don't like exposing this information only on title processes.

>> I tend to build the simplest possible thing that is useful enough to work.

> By only putting it in the ps display, you exclude all the users who
> don't have an easy way to look at that information. The big group
> there is Windows, but it's not necessarily easy on all other platforms
> as well, afaik.

Yeah. Also, process title updates are friggin expensive on some
platforms --- so much so, that we have a GUC setting to disable them.
So I don't think we should use that technique at all. Put the info
into the stats collector instead (not "also").

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-08-18 14:07:02 Re: vacuum rusage fix
Previous Message Heikki Linnakangas 2011-08-18 13:57:34 Re: SSI 2PC coverage