Vacuum and Transactions

From: Rod Taylor <pg(at)rbt(dot)ca>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Vacuum and Transactions
Date: 2005-10-04 04:26:56
Message-ID: 1128400016.6543.176.camel@home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

As I understand it vacuum operates outside of the regular transaction
and if you stop it (SIGTERM, or pg_cancel_backend()) some of the work it
accomplished will be kept when it rolls back.

For large structures with a ton of dead entries (which I seem to have a
case), running vacuum takes long enough that high-churn structures begin
to experience difficulties.

Is it reasonable to cancel and restart the vacuum process periodically
(say every 12 hours) until it manages to complete the work? It takes
about 2 hours to do the table scan, and should get in about 10 hours of
index work each round.

The vacuum ignores vacuum transaction concept looks handy right now.

--

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2005-10-04 06:47:57 Re: PG Killed by OOM Condition
Previous Message Tom Lane 2005-10-04 04:21:28 Re: Tuning current tuplesort external sort code for 8.2