Hello all - I was looking for a way to find out how much disk space each table is using.
I stumbled upon this page ( http://www.ffnn.nl/pages/articles/linux/postgresql-tips-and-tricks.php ) which gave me a query to show the number of disk pages per object. Given that a page is 8kb, I added these calculated columns to the query: SELECT relname, reltuples, relpages, relpages * 8 AS relpagesKB, (relpages * 8 )/1024 AS relpagesMB FROM pg_class ORDER BY relpages DESC ; Is this correct? ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
