Postgres Pro
Downloads
Home   >   mailing lists

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

From Glyn Astill
Subject Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)
Date
Msg-id 736208.74368.qm@web26007.mail.ukl.yahoo.com
Whole thread Raw
In response to Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)
List pgsql-admin
Tree view 
--- On Mon, 4/4/11, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > So it appears now that if I restore the database using
> pg_restore, I end up with bloated indexes, which are fixed
> with a 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?
>

It's a newly created database from a schema only dump.

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: DB Import Error...
Next
From: Tom Lane
Date:
Subject: Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)