Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum Hung Due to Bufferpin - Mailing list pgsql-general

From Tom Lane
Subject Re: Autovacuum Hung Due to Bufferpin
Date
Msg-id 668742.1673471220@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autovacuum Hung Due to Bufferpin  (Fred Habash <fmhabash@gmail.com>)
List pgsql-general
Tree view 
Fred Habash <fmhabash@gmail.com> writes:
> According to pgstattuple, dead_tuple_count = 0. If this is the case, then
> what other explanations do we have?

Could be that old tuple(s) now require freezing.

> I mean, how can I find out what blocker
> session is holding the bufferpin to terminate it?

I don't think there's any ready way to discover that from SQL level.

            regards, tom lane

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Changing displayed time zone in RAISE NOTICE output?
Next
From: Ron
Date:
Subject: Re: Changing displayed time zone in RAISE NOTICE output?