Thread: size estimates
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?
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?
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?