Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Lock Statistics
- From: adey <adey11(at)gmail(dot)com>
- To: "Michael Fuhr" <mike(at)fuhr(dot)org>
- Cc: "Milen A. Radev" <milen(at)radev(dot)net>, pgsql-admin(at)postgresql(dot)org
- Subject: Re: Lock Statistics
- Date: Tue, 31 Jul 2007 15:13:14 +1200
On 7/31/07, Michael Fuhr <mike(at)fuhr(dot)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
- References:
- Lock Statistics
- From: Milen A. Radev
- Re: Lock Statistics
- From: adey
- Re: Lock Statistics
- From: Michael Fuhr
- Lock Statistics
- Prev by Date: Re: Question about fixes and updates
- Next by Date: alter table table add column
- Previous by thread: Re: Lock Statistics
- Next by thread: Re: Lock Statistics
- Indexes: