| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Shane Wright <shane(dot)wright(at)edigitalresearch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: recovery from xid wraparound |
| Date: | 2006-10-24 14:51:25 |
| Message-ID: | 20061024145125.GF30158@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Oct 24, 2006 at 03:47:52PM +0100, Shane Wright wrote:
>
> Incidentally, how many passes of a table can vacuum make! Its currently
> on its third trip through the 20Gb of indices, meaning another 7 hours
> till completion [of this table]!.
>
> Assume it only does three passes? (it chooses based on the table
> continuing to be updated while vacuum is running)
It depends on how many tuples it needs to process and how much memory
you gave it (the maintainence_work_mem settings). The more memory you
give it, the less passes it needs to do...
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-10-24 14:52:16 | Re: recovery from xid wraparound |
| Previous Message | Alvaro Herrera | 2006-10-24 14:50:18 | Re: recovery from xid wraparound |