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.
--
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 |