Re: [PROPOSAL] VACUUM Progress Checker.

​Something like that would be helpful. I just had to stop one after an
hour and have no idea how much longer it would have taken.​

__________________________________________________________________________________
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike(dot)Blackwell(at)rrd(dot)com
http://www.rrdonnelley.com

<http://www.rrdonnelley.com/>
* <Mike(dot)Blackwell(at)rrd(dot)com>*

On Fri, Jul 24, 2015 at 5:41 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:

> On 07/24/2015 11:06 AM, Jim Nasby wrote:
> > 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.
>
> What about just reporting scanned pages/total pages ? That would be
> easy and cheap to track. It would result in some herky-jerky
> "progress", but would still be an improvement over the feedback we don't
> have now.
>
> --
> Josh Berkus
> PostgreSQL Experts Inc.
> http://pgexperts.com
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>