Re: Lock Statistics - Mailing list pgsql-admin

From adey
Subject Re: Lock Statistics
Date
Msg-id 1c66bda80707302013xca6c726gc981ca52f4d562d0@mail.gmail.com
Whole thread Raw
In response to Re: Lock Statistics  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin


On 7/31/07, Michael Fuhr <mike@fuhr.org> wrote:
On Tue, Jul 31, 2007 at 10:35:25AM +1200, adey wrote:
> -- CAUTION: this query may impact system performance as you are selecting
> from system tables

What difference are you expecting that to make and why?
 
It was a warning I received some years ago when I riginally discovered the query. Presumably reading from system tables competes with user queries for the system tables, slowing them down. I can't say I've ever noticed any impact when using it though.

--
Michael Fuhr

pgsql-admin by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Question about fixes and updates
Next
From: Ronald Rojas
Date:
Subject: alter table table add column