Sat May 24 11:26:10 PDT 2008
- Previous message: [Slony1-general] auto vac output: Page Slots
- Next message: [Slony1-general] Slon Bloat or question re master and slave reported bloat
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
So full of questions today and it's a Saturday, well guess that's the nature of the beast. Postgres 8.3.1 slon 1.2.14 Question is why there seems to be such a difference in size between the master and the slave. SLAVE POSTGRES_BLOAT OK: DB "clsdb" (host:idb02.domain.com) table cls.listings rows:1608406 pages:335434 shouldbe:222939 (1.5X) wasted size:921559040 (879 MB) | time=2.32 cls.listings=921559040 MASTER POSTGRES_BLOAT OK: DB "clsdb" (host:idb01.domain.com) table cls.listings rows:1599038 pages:292044 shouldbe:222460 (1.3X) wasted size:570032128 (544 MB) | time=2.57 cls.listings=570032128 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? The hardware is identical, the settings/conf are identical, I was just thinking that the db's would track more closely. Thanks Tory
- Previous message: [Slony1-general] auto vac output: Page Slots
- Next message: [Slony1-general] Slon Bloat or question re master and slave reported bloat
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list