Re: storage calculations - Mailing list pgsql-admin

From pgboy@guthrie.charm.net
Subject Re: storage calculations
Date
Msg-id 20030730114317.3F7E113E23@guthrie.charm.net
Whole thread Raw
In response to storage calculations  (pgboy@guthrie.charm.net)
Responses Re: storage calculations
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Dani Oderbolz
Date:
Subject: Re: Replication/Failover/HA solution
Next
From: Tom Lane
Date:
Subject: Re: syslog enabled causes random hangs?