Re: storage calculations

Поиск
Список
Период
Сортировка
От pgboy@guthrie.charm.net
Тема Re: storage calculations
Дата
Msg-id 20030730114317.3F7E113E23@guthrie.charm.net
обсуждение исходный текст
Ответ на storage calculations  (pgboy@guthrie.charm.net)
Ответы Re: storage calculations  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Dani Oderbolz
Дата:
Сообщение: Re: Replication/Failover/HA solution
Следующее
От: Tom Lane
Дата:
Сообщение: Re: syslog enabled causes random hangs?