Wed May 28 09:03:48 PDT 2008
- Previous message: [Slony1-general] Slon Bloat or question re master and slave reported bloat
- Next message: [Slony1-general] pg_dump/pg_restore keeping all slony stuff intact?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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
- Previous message: [Slony1-general] Slon Bloat or question re master and slave reported bloat
- Next message: [Slony1-general] pg_dump/pg_restore keeping all slony stuff intact?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list