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.
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2003-07-30 13:41:29|
|Subject: Re: syslog enabled causes random hangs? |
|Previous:||From: Dani Oderbolz||Date: 2003-07-30 11:10:06|
|Subject: Re: Replication/Failover/HA solution|