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

Re: Question

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net>
Cc: Postgresql Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Question
Date: 2004-02-21 16:37:58
Message-ID: 1077381478.31467.11.camel@jester (view raw or flat)
Thread:
Lists: pgsql-advocacy
On Sat, 2004-02-21 at 11:10, Shridhar Daithankar wrote:
> Rod Taylor wrote:
> 
> 
> > rbt=# select nspname, sum(relpages) from pg_class join pg_namespace n on
> > (relnamespace = n.oid) group by nspname, relnamespace having 2 > (SELECT
> > count(*) from pg_constraint where relnamespace = connamespace);
> > 
> > With some effort you might be able to get the above down to a single
> > line (shorter column names, etc.).
> > 
> > It takes the sum of pages used by relations in namespaces with a minimum
> > of 2 constraints.
> 
> I think any query fiddling with metadata is a bad idea for a sig.

Of course. I was simply demonstrating a query class that is complicated
which many databases probably don't support, PostgreSQL didn't until
recently, but is in the spec.

-- 
Rod Taylor <rbt [at] rbt [dot] ca>

Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
PGP Key: http://www.rbt.ca/signature.asc

In response to

  • Re: Question at 2004-02-21 16:10:30 from Shridhar Daithankar

pgsql-advocacy by date

Next:From: Rod TaylorDate: 2004-02-21 16:39:16
Subject: [Fwd: Re: Question]
Previous:From: David CostaDate: 2004-02-21 16:16:09
Subject: Re: Question

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