bloating index, pg_restore

From: salah jubeh <s_jubeh(at)yahoo(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: bloating index, pg_restore
Date: 2013-03-27 16:56:23
Message-ID: 1364403383.2962.YahooMailNeo@web122206.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a database which is bloated because of vacuum full, so you find indexes bigger than the table itself.

I have dumped this database and restored it without reindixing and it was extremely slow. So, my question what is the relation between bloated database and pg_restore.  

Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hamann.w 2013-03-27 16:56:37 Re: pltcl and modules question
Previous Message Tom Lane 2013-03-27 16:43:05 Re: money with 4 digits after dot