Re: Database storage bloat

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: reina_ga(at)hotmail(dot)com (Tony Reina)
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database storage bloat
Date: 2004-04-08 14:15:19
Message-ID: 13514.1081433719@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

reina_ga(at)hotmail(dot)com (Tony Reina) writes:
> However, a 65X bloat in space seems excessive.

Without concrete details about your schema, it's hard to answer that.
I suspect you made some inefficient choices, but have no data.

For starters you should do a database-wide VACUUM to ensure
pg_class.relpages is up to date, then look to see which tables and
indexes contain the most pages.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-04-08 14:19:16 Re: CONTEXT: in log file
Previous Message Tom Bakken 2004-04-08 14:08:51 Re: Out of space