Re: Maintenance question / DB size anomaly...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kurt Overberg <kurt(at)hotdogrecords(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Maintenance question / DB size anomaly...
Date: 2007-06-19 14:12:05
Message-ID: 27182.1182262325@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2007-06-19 14:13:30 Re: Maintenance question / DB size anomaly...
Previous Message Karl Wright 2007-06-19 14:06:25 Re: Performance query about large tables, lots of concurrent access