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

Vacuum DB

From: "Sokel, John" <jsokel(at)mdsi-usa(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Vacuum DB
Date: 2000-08-31 18:31:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Being a relative newcomer to PostgreSQL, can someone give me quick tour of
the vacuum function.  The application that I built uses PostgreSQL as a
statistics database (running on RedHat 6.2).  It will typically make
10000-20000 SQL updates/inserts per hour.  This is fine at first, but as the
day progresses, the updates start falling behind, and the CPU usage by the
postmaster process starts heading toward 70-80%.  When I do a vacuum, the
updates speed up dramatically, and the cpu usage goes back down to about

The questions are:
Is there a general rule on how often to run a Vacuum?
Is there an Auto Vacuum setting to have the postmaster to this
Is there a better approach to keeping this situation from happening (like
bundling many updates into a single transaction)?

Any info would be appreciated.

John Sokel


pgsql-novice by date

Next:From: Marc ZandvlietDate: 2000-08-31 18:43:03
Subject: Modifying tables
Previous:From: Thomas GoodDate: 2000-08-31 16:25:37
Subject: Re: Failing to boot Postgres on Red Hat Linux

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