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

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

Предыдущее
От: Brian Fehrle
Дата:
Сообщение: Explore contents of WAL files
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: DB Import Error...