Postgres Pro
Downloads
Home   >   mailing lists

Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?) - Mailing list pgsql-admin

From Tom Lane
Subject Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)
Date
Msg-id 872.1301932933@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)  (Glyn Astill <glynastill@yahoo.co.uk>)
Responses Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)  (Glyn Astill <glynastill@yahoo.co.uk>)
List pgsql-admin
Tree view 
Glyn Astill <glynastill@yahoo.co.uk> writes:
> So it appears now that if I restore the database using pg_restore, I end up with bloated indexes, which are fixed
witha vacuum full. 

> The dump is a data only dump with the -Fc flag,

Data only dump?  Then what is the state of the database you're restoring
it into?

            regards, tom lane

pgsql-admin by date:

Previous
From: Brian Fehrle
Date:
Subject: Explore contents of WAL files
Next
From: "Kevin Grittner"
Date:
Subject: Re: DB Import Error...