Re: Progress reporting for pg_verify_checksums

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
Re: Progress reporting for pg_verify_checksums
Дата
Msg-id
alpine.DEB.2.21.1904020805030.10740@lancre
Ответ на
Список
Дерево обсуждения
Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Thomas Munro <thomas.munro@enterprisedb.com>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Bernd Helmle <mailings@oopsware.de>
Re: Progress reporting for pg_verify_checksums Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <fabien.coelho@mines-paristech.fr>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Progress reporting for pg_verify_checksums Michael Paquier <michael@paquier.xyz>
Re: Progress reporting for pg_verify_checksums Dmitry Dolgov <9erthalion6@gmail.com>
Re: Progress reporting for pg_verify_checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Progress reporting for pg_verify_checksums Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Progress reporting for pg_verify_checksums Michael Banck <michael.banck@credativ.de>
Re: Progress reporting for pg_verify_checksums Thomas Munro <thomas.munro@enterprisedb.com>

Bonjour Michaël,

>> Maybe it should be -P X where X is the expected
>> delay in seconds. Pgbench progress reporting on initialization basically
>> outputs 10 rows per second, probably it is too much.
>
> I cannot say for pgbench.  I personally think that's a lot but you are
> the one who wrote it as such I guess.

Nope, this was way before I intervened. ISTM that a patch was submitted to 
get per second or slower progress reporting on the initalization, and it 
was rejected. Now that there are many SSD, maybe I could bring it back. An 
issue with pbbench is that the reported time and progress is for the 
insertion phase only, but PK and other FK declaration take as much time 
and are not included, so I'm not sure it can be much better.

For pg_checksums, probably some improvement patch will be submitted later, 
if someone feels like it.

-- 
Fabien.
В списке pgsql-hackers по дате отправления
От: Haribabu Kommi
Дата:
От: Darafei Komяpa Praliaskouski
Дата:
Сообщение: Re: Compressed TOAST Slicing
FAQ