Re: [PROPOSAL] VACUUM Progress Checker.

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: [PROPOSAL] VACUUM Progress Checker.
Дата
Msg-id CAFj8pRBYEEh+WFqQzkCnLLURrrZuC5FX4DHebzwavcch=44ZSw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PROPOSAL] VACUUM Progress Checker.  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers


2015-07-25 0:41 GMT+02:00 Josh Berkus <josh@agliodbs.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Supporting TAP tests with MSVC and Windows
Следующее
От: Marc Mamin
Дата:
Сообщение: Re: pg_dump -Fd and compression level