vacuum verbose: show pages marked allvisible/frozen/hintbits - Mailing list pgsql-hackers

From Justin Pryzby
Subject vacuum verbose: show pages marked allvisible/frozen/hintbits
Date
Msg-id 20200126141328.GP13621@telsasoft.com
Whole thread Raw
Responses Re: vacuum verbose: show pages marked allvisible/frozen/hintbits
List 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.

Attachment

pgsql-hackers by date:

Previous
From: Christoph Berg
Date:
Subject: Re: Add %x to PROMPT1 and PROMPT2
Next
From: Justin Pryzby
Date:
Subject: Re: explain HashAggregate to report bucket and memory stats