Unix Technical Forum

Re: DBSize backend integration

This is a discussion on Re: DBSize backend integration within the pgsql Hackers forums, part of the PostgreSQL category; --> > -----Original Message----- > From: Bruce Momjian [mailto gman@candle.pha.pa.us] > Sent: 24 June 2005 20:45 > To: Dave Page ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-11-2008, 05:33 AM
Dave Page
 
Posts: n/a
Default Re: DBSize backend integration



> -----Original Message-----
> From: Bruce Momjian [mailtogman@candle.pha.pa.us]
> Sent: 24 June 2005 20:45
> To: Dave Page
> Cc: PostgreSQL-development
> Subject: Re: [HACKERS] DBSize backend integration
>
> > My personal view is that pg_database_size, pg_relation_size and
> > pg_tablespace_size, as well as pg_size_pretty should be included. If
> > others consider that the by name versions are also useful, then they
> > should be included, but renamed for consistency. The other three
> > functions should be dropped IMO.

>
> So drop total_relation_size(), relation_size_components(), and what
> else?


indexes_size()

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-11-2008, 05:33 AM
Bruce Momjian
 
Posts: n/a
Default Re: DBSize backend integration

Dave Page wrote:
>
>
> > -----Original Message-----
> > From: Bruce Momjian [mailtogman@candle.pha.pa.us]
> > Sent: 24 June 2005 20:45
> > To: Dave Page
> > Cc: PostgreSQL-development
> > Subject: Re: [HACKERS] DBSize backend integration
> >
> > > My personal view is that pg_database_size, pg_relation_size and
> > > pg_tablespace_size, as well as pg_size_pretty should be included. If
> > > others consider that the by name versions are also useful, then they
> > > should be included, but renamed for consistency. The other three
> > > functions should be dropped IMO.

> >
> > So drop total_relation_size(), relation_size_components(), and what
> > else?

>
> indexes_size()


What is the logic for removing that? Because it is an aggregate of all
indexes?

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:35 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com