Re: measuring disk usage of records
От | Matthew Nuzum |
---|---|
Тема | Re: measuring disk usage of records |
Дата | |
Msg-id | 000001c3cfe5$a56d73e0$6900a8c0@MATTSPC обсуждение исходный текст |
Ответ на | Re: measuring disk usage of records ("P.J. \"Josh\" Rovero" <rovero@sonalysts.com>) |
Ответы |
Re: measuring disk usage of records
Re: measuring disk usage of records |
Список | pgsql-general |
Thanks for the very quick reply... I didn't know about the dbsize stuff, they may help. Unfortunately, the records are mixed together. I may have to use some judicious estimating... I'm just wondering if there's something more scientific. Matthew Nuzum | ISPs: Make $200 - $5,000 per referral by www.followers.net | recomending Elite CMS to your customers! matt@followers.net | http://www.followers.net/isp -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of P.J. "Josh" Rovero Sent: Wednesday, December 31, 2003 4:20 PM To: Matthew Nuzum Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] measuring disk usage of records Use contrib/dbsize, then you'll be able to select relation_size('<table_name>'); select database_size('<database_name>'); Answers come back in bytes.... If the customer records are mixed with different customer data in the same tables, it's a bit more complicated. Matthew Nuzum wrote: > Therefore, we'd like to avoid falling into the same trap and get a good > understanding of how much storage space our customer's data is actually > using. > > Here's the problem... A customer's data may be scattered across multiple > tables. Some customers have X,000 records in table A, some have Y,000 > records in table B and etc. There's no way it can be as simple as saying > "database takes X GB for Y customers so usage is X/Y" > > Does anyone have any suggestions that can help me to get access to this > information? -- P. J. "Josh" Rovero Sonalysts, Inc. Email: rovero@sonalysts.com www.sonalysts.com 215 Parkway North Work: (860)326-3671 or 442-4355 Waterford CT 06385 *********************************************************************** ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
В списке pgsql-general по дате отправления: