Re: Full vacuuming of BIG tables takes too long - Mailing list pgsql-admin

From Eugene M. Zheganin
Subject Re: Full vacuuming of BIG tables takes too long
Date
Msg-id 1841310057656.20030526134851@norma.perm.ru
Whole thread Raw
In response to Re: Full vacuuming of BIG tables takes too long  (Robert Treat <xzilla@users.sourceforge.net>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: vacuum info - crash
Next
From: "Nathalie Boulos"
Date:
Subject: Backup passwd protected DB