On Wed, Mar 14, 2012 at 8:06 PM, Aleksey Tsalolikhin <atsaloli.t...@gmail.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
