Greg Sabino Mullane greg at endpoint.com
Wed May 28 09:03:48 PDT 2008
> Question is why there seems to be such a difference in size between
> the master and the slave.
...
> cls.listings rows:1608406 pages:335434 shouldbe:222939 (1.5X) wasted
...
> cls.listings rows:1599038 pages:292044 shouldbe:222460 (1.3X) wasted
...
> Yes I checked the autovacs and they ran 2 hours apart but during a
> time of low traffic, this would not explain the pretty significant
> difference in wasted space.. I'm wondering where I should start to
> look and or if I should waste any effort on tracking this down?

Try ANALYZING both right before running the check, to get the best row and
pages estimates. At the very least, the number of rows should match much
closer than they are. It may just be that the vacuum on the slave side did
not run as recently as the master, or could not completely remove all dead
tuples. Compare ANALYZE VERBOSE on both sides for a closer look at the
differences.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20080528/27fc6091/signature.pgp


More information about the Slony1-general mailing list