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

Поиск
Список
Период
Сортировка
От Greg Williamson
Тема Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Дата
Msg-id 1331855059.93188.YahooMailNeo@web46110.mail.sp1.yahoo.com
обсуждение исходный текст
Ответ на Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?  (Filip Rembiałkowski <plk.zuber@gmail.com>)
Ответы Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
Список pgsql-general
Filip Rembiałkowski suggested:


>> On Thu, Mar 15, 2012 at 6:43 AM, Aleksey Tsalolikhin <atsaloli.tech@gmail.com> wrote:
>>
>>
>> Is there any way to consolidate the pages on the slave without taking
>> replication offline?
>>
>>
>maybe CLUSTER?
>
<...>
>
>Of course events destined to this table will be queued by Slony while the table is locked.
>

I've not much recent experience with Slony, but possibly pg_reorg, found at:

  <http://pgfoundry.org/projects/reorg/>

would be of use ...

Greg Williamson

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

Предыдущее
От: Doug Gorley
Дата:
Сообщение: Zero-length character breaking query?
Следующее
От: BrunoSteven
Дата:
Сообщение: Problem for restoure data base Postgre