Re: Vacuum and Transactions - Mailing list pgsql-hackers

From Zeugswetter Andreas DAZ SD
Subject Re: Vacuum and Transactions
Date
Msg-id E1539E0ED7043848906A8FF995BDA5797EFEA4@m0143.s-mxs.net
Whole thread Raw
In response to Vacuum and Transactions  (Rod Taylor <pg@rbt.ca>)
List pgsql-hackers
> > 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.

If we started the vacuum with the indexes, remembered a lowest xid per
index,
we could then vacuum the heap up to the lowest of those xids, no ?
We could then also vacuum each index separately.

Andreas


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Vacuum and Transactions
Next
From: Philip Yarra
Date:
Subject: Slony RPM issue