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

Поиск
Список
Период
Сортировка
От Glyn Astill
Тема Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)
Дата
Msg-id 736208.74368.qm@web26007.mail.ukl.yahoo.com
обсуждение исходный текст
Ответ на Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)
Список pgsql-admin
Дерево обсуждения 
--- 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: DB Import Error...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)