vacuum verbose: show pages marked allvisible/frozen/hintbits

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема vacuum verbose: show pages marked allvisible/frozen/hintbits
Дата
Msg-id 20200126141328.GP13621@telsasoft.com
обсуждение исходный текст
Ответы Re: vacuum verbose: show pages marked allvisible/frozen/hintbits
Список pgsql-hackers
I'm forking this thread since it's separate topic, and since keeping in a
single branch hasn't made maintaining the patches any easier.
https://www.postgresql.org/message-id/CAMkU%3D1xAyWnwnLGORBOD%3Dpyv%3DccEkDi%3DwKeyhwF%3DgtB7QxLBwQ%40mail.gmail.com
On Sun, Dec 29, 2019 at 01:15:24PM -0500, Jeff Janes wrote:
> Also, I'd appreciate a report on how many hint-bits were set, and how many
> pages were marked all-visible and/or frozen.  When I do a manual vacuum, it
> is more often for those purposes than it is for removing removable rows
> (which autovac generally does a good enough job of).

The first patch seems simple enough but the 2nd could use critical review.

Вложения

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

Предыдущее
От: Christoph Berg
Дата:
Сообщение: Re: Add %x to PROMPT1 and PROMPT2
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: explain HashAggregate to report bucket and memory stats