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

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Date: 2012-03-17 09:53:40
Message-ID: C9C644E9-775E-464F-A11A-013BCC5D8B73@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 17 Mar 2012, at 4:21, Aleksey Tsalolikhin wrote:

> And I still don't know why I have holes in my pages....... should I have holes
> in my pages?? why only on the slave and not on the master? (the slave has
> 4x the number of pages compared to the master, and there's less rows per
> page on the slave.)

I recall someone in here had a similar problem where the table's FILLFACTOR on the slave was different from the one on the master. Perhaps that would explain the gaps you're seeing?

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2012-03-17 09:58:07 Re: Temporal foreign keys
Previous Message prem tolani 2012-03-17 07:04:07 One more query