Postgres Pro
Downloads
Home   >   mailing lists

bloating index, pg_restore - Mailing list pgsql-general

From salah jubeh
Subject bloating index, pg_restore
Date
Msg-id 1364403383.2962.YahooMailNeo@web122206.mail.ne1.yahoo.com
Whole thread Raw
Responses Re: bloating index, pg_restore
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: hamann.w@t-online.de
Date:
Subject: Re: pltcl and modules question
Next
From: Clemens Eisserer
Date:
Subject: Is there any way to listen to NOTIFY in php without polling?