Re: Full vacuuming of BIG tables takes too long

Поиск
Список
Период
Сортировка
От Eugene M. Zheganin
Тема Re: Full vacuuming of BIG tables takes too long
Дата
Msg-id 1841310057656.20030526134851@norma.perm.ru
обсуждение исходный текст
Ответ на Re: Full vacuuming of BIG tables takes too long  (Robert Treat <xzilla@users.sourceforge.net>)
Список pgsql-admin
Hello Robert,

Thursday, May 22, 2003, 8:01:58 PM, you wrote:

RT> On Thu, 2003-05-22 at 08:37, Eugene M. Zheganin wrote:

RT> My first suggestion would be to check  your free space map settings in
RT> the postgresql.conf and make sure they are set high enough.
They are set to defaults.

RT>   Setting
RT> them to low can cause Vacuum Full to take longer than necessary.
I read " Server Run-time Environment" from Postgresql docs, but I
don't understand how I can calculate optimum values ? (where I can
read about it in pgsql docs ?)

Can you give me any further explanations 8) ?

--
Best regards,
 Eugene                            mailto:emz@norma.perm.ru


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: vacuum info - crash
Следующее
От: "Nathalie Boulos"
Дата:
Сообщение: Backup passwd protected DB