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

On Wed, Mar 14, 2012 at 8:06 PM, Aleksey Tsalolikhin
<atsaloli(dot)tech(at)gmail(dot)com> wrote:
> Executive summary:  Why would the TOAST table on the slave have 4x the
> page count of the master?

Hypothesis: the pages of the TOAST table on the slave have more
unused space in them than the pages of the TOAST table on the master.

How do I test this hypothesis? I need to examine the raw pages on disk.

I'm looking at
http://momjian.us/main/writings/pgsql/internalpics.pdf Slide 52
shows "internal page structure" but I don't know how to actually look
at a page.
Is it possible to do a raw dump of the pages of a table? Do I just
look at the hexdump of the file corresponding to relfilenode?

Best,
Aleksey