detection of VACUUM in progress

From: Bohdan Linda <bohdan(dot)linda(at)seznam(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: detection of VACUUM in progress
Date: 2005-08-30 15:35:13
Message-ID: 20050830153513.GA19830@bafster.chello.upc.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Is there any way how to detect running command VACUUM by reading pg_* tables?

The idea is to detectect when table is not accessible due maintainance. The approach of explicitely setting a flag into status table is not very convenient, while I want to cover also non-systematic launching of this command

Regards,
Bohdan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-08-30 15:53:56 Re: detection of VACUUM in progress
Previous Message Hossein S. Attar 2005-08-30 15:32:11 Re: postgres optimizer