pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: adey <adey11@gmail.com>
To: Michael Fuhr <mike@fuhr.org>
Cc: Milen A. Radev <milen@radev.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Lock Statistics
Date: Tue, 31 Jul 2007 15:13:14 +1200
Message-ID: <1c66bda80707302013xca6c726gc981ca52f4d562d0@mail.gmail.com> (raw)
In-Reply-To: <20070731022259.GC23999@winnie.fuhr.org>
References: <32c009ea0707300911h74f588f6se7d03f5f28d598e5@mail.gmail.com>
	<1c66bda80707301535s24e675f4i483b06f91351289e@mail.gmail.com>
	<20070731022259.GC23999@winnie.fuhr.org>

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
>

view thread (5+ messages)

Message-ID: <1c66bda80707302013xca6c726gc981ca52f4d562d0@mail.gmail.com>
Permalink:  ../1c66bda80707302013xca6c726gc981ca52f4d562d0@mail.gmail.com/
Also on:    postgresql.org/message-id/1c66bda80707302013xca6c726gc981ca52f4d562d0@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: adey11@gmail.com, mike@fuhr.org, milen@radev.net
  Subject: Re: Lock Statistics
  In-Reply-To: <1c66bda80707302013xca6c726gc981ca52f4d562d0@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox