Re: Maintenance question / DB size anomaly... - Mailing list pgsql-performance

From Tom Lane
Subject Re: Maintenance question / DB size anomaly...
Date
Msg-id 27182.1182262325@sss.pgh.pa.us
Whole thread Raw
In response to Maintenance question / DB size anomaly...  (Kurt Overberg <kurt@hotdogrecords.com>)
List pgsql-performance
Kurt Overberg <kurt@hotdogrecords.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

pgsql-performance by date:

Previous
From: Karl Wright
Date:
Subject: Re: Performance query about large tables, lots of concurrent access
Next
From: Richard Huxton
Date:
Subject: Re: Maintenance question / DB size anomaly...