Re: Table size on disk
От | Bruce Momjian |
---|---|
Тема | Re: Table size on disk |
Дата | |
Msg-id | 200305222220.h4MMKsH10710@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Table size on disk ("Cristina Surroca" <cris@dmcid.net>) |
Список | pgsql-admin |
See monitoring disk space chapter in the docs. --------------------------------------------------------------------------- Cristina Surroca wrote: > select relname, relpages from pg_class; > relname is the table name. > relpages is number of pages of 8 K that needs the table to be stored. > > (sorry for my English) > > yours > > Cris.. > ----- Original Message ----- > From: "Kris Kiger" <kris@musicrebellion.com> > Cc: <pgsql-admin@postgresql.org> > Sent: Tuesday, May 20, 2003 4:58 PM > Subject: [ADMIN] Table size on disk > > > > Is there a good way to tell how much physical space a table takes on > > disk? Thanks > > > > Kris > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faqs/FAQ.html > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-admin по дате отправления: