Re: Displaying accumulated autovacuum cost - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Displaying accumulated autovacuum cost
Date
Msg-id 226237CA-2DCA-4655-9B1F-CCFCF906B6A3@nasby.net
Whole thread Raw
In response to Re: Displaying accumulated autovacuum cost  (Greg Smith <greg@2ndQuadrant.com>)
Responses Re: Displaying accumulated autovacuum cost
List pgsql-hackers
On Aug 18, 2011, at 10:41 AM, Greg Smith wrote:
> that was all they got.  I'm going to add directly computing the write MB/s figure from the dirty data written too,
sincethat ends up being the thing that I keep deriving by hand anyway. 

I know folks have talked about progress, but I haven't seen anything specific... could you add info about what
table/indexvacuum is working on, and how far along it is? I realize that's not very close to an actual % completion,
butit's far better than what we have right now. 

FWIW, the number I end up caring about isn't so much write traffic as read. Thanks to a good amount of battery-backed
writecache (and possibly some iSCSI misconfiguration), our writes are generally much cheaper than our reads. 
--
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net




pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: How to define global variable in postgresql
Next
From: Robert Haas
Date:
Subject: Re: 9.1rc1: TRAP: FailedAssertion("!(item_width > 0)", File: "costsize.c", Line: 3274)