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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
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:02:13
Message-ID: 872.1301932933@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk> writes:
> 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?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-04-04 16:12:08 Re: DB Import Error...
Previous Message Brian Fehrle 2011-04-04 15:30:49 Explore contents of WAL files