Re: pg_walinspect - a new extension to get raw WAL data and WAL stats

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: pg_walinspect - a new extension to get raw WAL data and WAL stats
Дата
Msg-id 20220401234447.ztuylaf6rbol2mvw@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: pg_walinspect - a new extension to get raw WAL data and WAL stats  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
Hi,

On 2022-04-01 16:35:38 -0700, Jeff Davis wrote:
> * I don't think we need the stats at all. We can run GROUP BY queries
> on the results of pg_get_wal_records_info().

It's well over an order of magnitude slower. And I don't see how that can be
avoided. That makes it practically useless.

See numbers at the bottom of
https://postgr.es/m/CALj2ACUvU2fGLw7keEpxZhGAoMQ9vrCPX-13hexQPoR%2BQRbuOw%40mail.gmail.com

Greetings,

Andres Freund



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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: pg_walinspect - a new extension to get raw WAL data and WAL stats
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Fix overflow in DecodeInterval