Re: [PROPOSAL] VACUUM Progress Checker.

2015-07-25 0:41 GMT+02:00 Josh Berkus <josh(at)agliodbs(dot)com>:

> 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.
>

I like this idea.

Regards

Pavel

>
> --
> 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
>