Postgres Pro
Downloads
Home   >   mailing lists

Signaling of waiting for a cleanup lock? - Mailing list pgsql-hackers

From Andres Freund
Subject Signaling of waiting for a cleanup lock?
Date
Msg-id 20140411142838.GP14419@alap3.anarazel.de
Whole thread Raw
Responses Re: Signaling of waiting for a cleanup lock?  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
Hi,

VACUUM sometimes waits synchronously for a cleanup lock on a heap
page. Sometimes for a long time. Without reporting it externally.
Rather confusing ;).

Since we only take cleanup locks around vacuum, how about we report at
least in pgstat that we're waiting? At the moment, there's really no way
to know if that's what's happening.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP patch (v2) for updatable security barrier views
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Negative Transition Aggregate Functions (WIP)