Re: How to specify fillrate after pg_restore?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to specify fillrate after pg_restore?
Дата
Msg-id 1702.1222832176@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How to specify fillrate after pg_restore?  (Laszlo Nagy <gandalf@shopzeus.com>)
Ответы Re: How to specify fillrate after pg_restore?
Список pgsql-admin
Laszlo Nagy <gandalf@shopzeus.com> writes:
> What will this do?

> ALTER TABLE tbl SET FILLFACTOR = 90;

> Will it restucture the table, or is it just a setting and I should
> perform a VACUUM to actually reach fillfactor=90?

It's just a setting ... and VACUUM won't do much with it either.

The best bet at the moment is to manually edit the pg_dump script
to insert such a command between creating the table and loading it.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Craig Perras
Дата:
Сообщение: sspi authentication
Следующее
От: Michael Monnerie
Дата:
Сообщение: Re: [GENERAL] 8.3.4 rpms for Opensuse10.3 64bit