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? ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org