Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Kenneth Marshall <ktm(at)rice(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)
Date: 2011-04-04 16:23:40
Message-ID: 736208.74368.qm@web26007.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

--- On Mon, 4/4/11, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2011-04-04 16:32:46 Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)
Previous Message Kevin Grittner 2011-04-04 16:12:08 Re: DB Import Error...