Re: [PROPOSAL] VACUUM Progress Checker. - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: [PROPOSAL] VACUUM Progress Checker.
Date
Msg-id 55B27EC0.9030809@BlueTreble.com
Whole thread Raw
In response to Re: [PROPOSAL] VACUUM Progress Checker.  ("Thakur, Sameer" <Sameer.Thakur@nttdata.com>)
Responses Re: [PROPOSAL] VACUUM Progress Checker.  (Rahila Syed <rahilasyed90@gmail.com>)
List pgsql-hackers
On 7/23/15 5:18 AM, Thakur, Sameer wrote:
> Hello,
>> >logged > 25 times
> Sorry, it is much lower at 7 times. Does not change overall point though

I think it's related to the problem of figuring out how many dead tuples 
you expect to find in the overall heap, which you need to do to have any 
hope of this being a comprehensive estimate.

My inclination at this point is to provide a simple means of providing 
the raw numbers and let users test it in the wild. A really crude method 
of doing that might be to trap SIGINFO (if we're not using it already) 
and elog current status.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PROPOSAL] VACUUM Progress Checker.
Next
From: Jim Nasby
Date:
Subject: Re: optimizing vacuum truncation scans