Bruce Momjian wrote: > becks wrote: > > hello. > > how to check disk space usage for a single table? > > Look at relpages in pg_class for that table. VACUUM the table first.
Actually, I wrote some stuff up for the 7.3 docs on this: http://developer.postgresql.org/docs/postgres/diskusage.html -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly