Disc space - UnUsed tuples

Поиск
Список
Период
Сортировка
От Rune
Тема Disc space - UnUsed tuples
Дата
Msg-id atcv5s$5is$1@main.gmane.org
обсуждение исходный текст
Ответы Re: Disc space - UnUsed tuples
Список pgsql-admin
I have a database with a table where new tuples are often added and then
updated. I get around 50000 new inserts every day, and every single tuple
gets an update one or more times. This I think is the reason that the
database takes up a lot more disc space then the actually data really need
(UnUsed tuples), and I need to free space. The database needs to run 24
hours a day, hence I cannot run vaccuum full to free space. My disc is
getting full and I sure would have appreciated it if someone could give me a
hint on what to do ?!?

Urle



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

Предыдущее
От: rstaudte@elkoop.de
Дата:
Сообщение: Tables, Functions, ... not visible
Следующее
От: HT Levine
Дата:
Сообщение: Followup Question about Vacuum from newsgroup