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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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