| From: | "Zeugswetter Andreas DAZ SD" <ZeugswetterA(at)spardat(dot)at> |
|---|---|
| To: | "Hannu Krosing" <hannu(at)skype(dot)net>, "Rod Taylor" <pg(at)rbt(dot)ca> |
| Cc: | "PostgreSQL Development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Vacuum and Transactions |
| Date: | 2005-10-05 07:38:40 |
| Message-ID: | E1539E0ED7043848906A8FF995BDA5797EFEA4@m0143.s-mxs.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Yarra | 2005-10-05 07:51:13 | Slony RPM issue |
| Previous Message | Hannu Krosing | 2005-10-05 07:03:29 | Re: Vacuum and Transactions |