Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Дата
Msg-id 4F5E6DB2.3070800@hogranch.com
обсуждение исходный текст
Ответ на Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?  ("Nur Hidayat" <hidayat365@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On 03/12/12 2:28 PM, Nur Hidayat wrote:
> If I didn't change the data type to charcater varying vaccuming the database doesn't reduce the database size

changing the data type required every tuple to get rewritten.     a
vacuum full, or a cluster likely would have done the same or better
reduction in size..



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: GROUP BY or alternative means to group
Следующее
От: Jim Ostler
Дата:
Сообщение: Matching on keyword or phrases within a field that is delimited with an "or" operator "|"