Re: storage calculations

From: pgboy(at)guthrie(dot)charm(dot)net
To: mendola(at)bigfoot(dot)com, pgsql-admin(at)postgresql(dot)org
Cc: pgboy(at)guthrie(dot)charm(dot)net
Subject: Re: storage calculations
Date: 2003-07-30 11:43:17
Message-ID: 20030730114317.3F7E113E23@guthrie.charm.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-07-30 13:41:29 Re: syslog enabled causes random hangs?
Previous Message Dani Oderbolz 2003-07-30 11:10:06 Re: Replication/Failover/HA solution