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

Re: Dbsize backend integration

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Dbsize backend integration
Date: 2005-06-29 11:45:44
Message-ID: 200506291145.j5TBjis29145@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Dave Page wrote:
> 
> 
> 
> -----Original Message----- From: Bruce Momjian
> [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us] Sent: Wed 6/29/2005 2:16 AM To: Dave
> Page Cc: PostgreSQL-patches; PostgreSQL-development Subject: Re:
> [PATCHES] Dbsize backend integration
> 
> > OK, so you went with relation as heap/index/toast only, and table as the
> > total of them.  I am not sure that makes sense because we usually equate
> > relation with table, and an index isn't a relation, really.
> 
> Err, yes - posted that before I got your reply!
> 
> > Do we have to use pg_object_size?  Is there a better name?  Are
> > indexes/toasts even objects?
> 
> Yeah, I think perhaps pg_object_size is better in some ways than
> pg_relation_size, however I stuck with relation because (certainly in
> pgAdmin world) we tend to think of pretty much anything as an object.
> I could go either way on that though, however Michael doesn't seem so
> keen.
> 
> So, one for pg_object_size, one on the fench and one against :-). Anyone
> else got a preference?

I have a new idea --- pg_storage_size().  That would do just the
toast/index/heap, and pg_relation_size() gets a total of them all, and
only works on heap, no index or toast.

How is that?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-06-29 11:49:57
Subject: Re: Open items
Previous:From: Oleg BartunovDate: 2005-06-29 11:41:01
Subject: Re: contrib/rtree_gist into core system?

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-06-29 11:49:57
Subject: Re: Open items
Previous:From: Dave PageDate: 2005-06-29 10:17:22
Subject: Re: Dbsize backend integration

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