Skip site navigation (1) Skip section navigation (2)

Re: Full vacuuming of BIG tables takes too long

From: "Eugene M(dot) Zheganin" <emz(at)norma(dot)perm(dot)ru>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Full vacuuming of BIG tables takes too long
Date: 2003-05-26 07:48:51
Message-ID: 1841310057656.20030526134851@norma.perm.ru (view raw or flat)
Thread:
Lists: 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(at)norma(dot)perm(dot)ru


In response to

pgsql-admin by date

Next:From: ewdaniDate: 2003-05-26 08:31:25
Subject: Inquiry From Form [pgsql]
Previous:From: Tom LaneDate: 2003-05-26 05:34:07
Subject: Re: vacuum info - crash

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group