Tory M Blue tmblue at gmail.com
Sat May 24 11:26:10 PDT 2008
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


More information about the Slony1-general mailing list