Re: Maintenance question / DB size anomaly...

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Kurt Overberg <kurt(at)hotdogrecords(dot)com> writes:
> In my investigation of this anomaly, I noticed that the data/ dir on  
> db1 (the master) is around 60 Gigs.  The data directory on the slaves  
> is around 25Gb.  After about 3 months of head scratching, someone on  
> the irc channel suggested that it may be due to index bloat.   

This is not something you need to guess about.  Compare the table and
index sizes, one by one, between the master and slaves.  Do a VACUUM
VERBOSE on the one(s) that are radically bigger on the master, and look
at what it has to say.

			regards, tom lane