Internal fragmentations statistics Was: VACUUM FULL memory requirements

Поиск
Список
Период
Сортировка
От Evan Rempel
Тема Internal fragmentations statistics Was: VACUUM FULL memory requirements
Дата
Msg-id 4B26C48F.4030501@uvic.ca
обсуждение исходный текст
Ответ на Re: VACUUM FULL memory requirements  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Internal fragmentations statistics Was: VACUUM FULL memory requirements  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-admin
Is there a command/tool that will report on how FULL a table is getting?
If there is, how intrusive is it? How computationally heavy is it?

We have a database that is approx 100 million rows with
approx 2 million insert/updates per day. Each day old data
is purged from the database. The end result is a mostly static
footprint with regards to disk space used, but I would like to
know how much room is usable inside the tables as well as the
OS file system (that part is easy).

--
Evan Rempel

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: VACUUM FULL memory requirements
Следующее
От: "Net Tree Inc."
Дата:
Сообщение: how to Stop(shutdown) specific database