Kurt Overberg <kurt@xxxxxxxxxxxxxxxxx> 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
