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