Re: size estimates

Ok, color me silly. I've found pg_statistic and with a few joins and the
FAQ, I have the information I'm looking for. Nix this last email.

Thanks,

L.
On Thu, 17 Oct 2002, Laurette Cisneros wrote:

> 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?