Re: size estimates - Mailing list pgsql-admin

From Laurette Cisneros
Subject Re: size estimates
Date
Msg-id Pine.LNX.4.44.0210171025370.23463-100000@visor.corp.nextbus.com
Whole thread Raw
In response to size estimates  (Laurette Cisneros <laurette@nextbus.com>)
Responses Re: size estimates  (Laurette Cisneros <laurette@nextbus.com>)
List 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?


pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: Fwd: [BUGS] Fwd: FATAL 1: Database dialup does not
Next
From: Laurette Cisneros
Date:
Subject: Re: size estimates