vacuum verbose no longer reveals anything about pins

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: vacuum verbose no longer reveals anything about pins
Date: 2022-06-30 12:57:00
Message-ID: CA+TgmobgZxZwxjSaiW_2ec8UHeJtAqVAMdyepA5kQOi3ABE=og@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I was dismayed to learn that VACUUM VERBOSE on a table no longer tells
you anything about whether any pages were skipped due to pins. Now the
obvious explanation for that is that we no longer skip pages entirely
just because we find that they are pinned. But I think failing to
fully process a page due to a pin is still a noteworthy event, and I
think that VACUUM VERBOSE should tell you how many times that
happened.

--
Robert Haas
EDB: http://www.enterprisedb.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Isaac Morland 2022-06-30 12:57:04 Re: pg_checkpointer is not a verb or verb phrase
Previous Message Robert Haas 2022-06-30 12:48:32 pg_checkpointer is not a verb or verb phrase