sorry, when i referred to "disk space used" i meant the actual amount used by live rows. if i insert 1000 rows then delete 999 of them, the disk file will be the size of the 100 row container (make that 1000, not 100 - i cannot backspace here) until i do a "vacuum full" - which does a table lock, which is a bad thing.
given that, i'd like to try to be able to calculate the number of bytes a row uses given its schema. i've seen this kind of documentation for other dbs, i just cannot seem to find it in the postgresql docs. thanks. pg ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html