Skip site navigation (1) Skip section navigation (2)

Re: Lock Statistics

From: adey <adey11(at)gmail(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: "Milen A(dot) Radev" <milen(at)radev(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Lock Statistics
Date: 2007-07-31 03:13:14
Message-ID: 1c66bda80707302013xca6c726gc981ca52f4d562d0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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
>

In response to

pgsql-admin by date

Next:From: Ronald RojasDate: 2007-07-31 04:19:47
Subject: alter table table add column
Previous:From: Michael FuhrDate: 2007-07-31 02:27:08
Subject: Re: Question about fixes and updates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group