Re: size estimates

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: size estimates
Date: 2002-10-17 17:27:21
Message-ID: Pine.LNX.4.44.0210171025370.23463-100000@visor.corp.nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Yes, indeed. Somewhat helpful. But, doesn't tell me how to find out what
the maximum size of rows are in each of my tables. Is there a way to do
this?

Also, it gives the overhead for each page and row in the table but not for
system tables (indexes, etc.). Is this somewhere?

Thank you for help,

Laurette
On Wed, 16 Oct 2002, Bruce Momjian wrote:

>
> See FAQ item on sizing.
>
> ---------------------------------------------------------------------------
>
> Laurette Cisneros wrote:
> >
> > Is there an easy way to do file size estimates for the data storage for the
> > each table, each database and the whole system if the size of each row per
> > table is known (but of course includes text fields)?
> >
> > Thanks,
> >
> > --
> > Laurette Cisneros
> > The Database Group
> > (510) 420-3137
> > NextBus Information Systems, Inc.
> > www.nextbus.com
> > ------------------------------
> > It's 10 o'clock...
> > Do you know where your bus is?
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
------------------------------
It's 10 o'clock...
Do you know where your bus is?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurette Cisneros 2002-10-17 17:44:29 Re: size estimates
Previous Message Robert Treat 2002-10-17 14:27:56 Re: Fwd: [BUGS] Fwd: FATAL 1: Database dialup does not