Re: [PROPOSAL] VACUUM Progress Checker.
| От | Mike Blackwell |
|---|---|
| Тема | Re: [PROPOSAL] VACUUM Progress Checker. |
| Дата | |
| Msg-id | CANPAkgsaqq7Gzu8zDWQQ6jC3Gsu8c12rLv75WHdjgUrGqZuJkA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [PROPOSAL] VACUUM Progress Checker. (Josh Berkus <josh@agliodbs.com>) |
| Список | pgsql-hackers |
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.Blackwell@rrd.com
http://www.rrdonnelley.com
On Fri, Jul 24, 2015 at 5:41 PM, Josh Berkus <josh@agliodbs.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления: