Re: Displaying accumulated autovacuum cost

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Displaying accumulated autovacuum cost
Дата
Msg-id 4E59FDE2.30900@2ndQuadrant.com
обсуждение исходный текст
Ответ на Re: Displaying accumulated autovacuum cost  (Greg Smith <greg@2ndQuadrant.com>)
Ответы Re: Displaying accumulated autovacuum cost  (Greg Smith <greg@2ndQuadrant.com>)
Список pgsql-hackers
Attached patch includes "math is hard" reworking, so it displays the
average write rate in the log output automatically:

LOG:  automatic vacuum of table "pgbench.public.pgbench_accounts": index
scans: 1
     pages: 0 removed, 163935 remain
     tuples: 2000000 removed, 4625165 remain
     buffer usage: 111901 hits, 123348 misses, 102351 dirtied, 23.365
MiB/s write rate
     system usage: CPU 1.84s/4.22u sec elapsed 34.22 sec

All of the updates to the process title are gone, in favor of some
progress report mechanism TBD.  The summary is much more important than
the progress tracking part as far as I'm concerned, I don't mind
splitting things apart to try and get this part in earlier.

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us



Вложения

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

Предыдущее
От: Gokulakannan Somasundaram
Дата:
Сообщение: Re: cheaper snapshots redux
Следующее
От: Dean Rasheed
Дата:
Сообщение: Re: Inputting relative datetimes