From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Dbsize backend integration |
Date: | 2005-07-02 20:29:49 |
Message-ID: | 200507022029.j62KTnm08736@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Is a new version of this patch coming?
---------------------------------------------------------------------------
Bruce Momjian wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-07-02 21:47:13 | Re: Dbsize backend integration |
Previous Message | Bruce Momjian | 2005-07-02 20:16:47 | Re: [PATCHES] O_DIRECT for WAL writes |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-07-02 21:47:13 | Re: Dbsize backend integration |
Previous Message | Bruce Momjian | 2005-07-02 20:28:48 | Re: per user/database connections limit again |