| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Hannu Krosing <hannu(at)skype(dot)net> |
| Subject: | Re: The vacuum-ignore-vacuum patch |
| Date: | 2006-07-28 16:03:20 |
| Message-ID: | 24952.1154102600@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Tom Lane wrote:
>> But the patch changes things so that *everyone* excludes the vacuum from
>> their xmin. Or at least I thought that was the plan.
> We shouldn't do that, because that Xmin is also used to truncate
> SUBTRANS.
Yeah, but you were going to change that, no? Truncating SUBTRANS will
need to include the vacuum xact's xmin, but we don't need it for any
other purpose.
> but it means
> lazy vacuum will never be able to use subtransactions.
This patch already depends on the assumption that lazy vacuum will never
do any transactional updates, so I don't see what it would need
subtransactions for.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2006-07-28 16:14:02 | Re: Re: [hackers-jp: 219] Re: postgresql-8.1.4文字セットサポート |
| Previous Message | Csaba Nagy | 2006-07-28 15:51:11 | Re: [CORE] Attack against postgresql.org ... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-07-28 16:22:54 | Re: [HACKERS] pgstattuple extension for indexes |
| Previous Message | Bruce Momjian | 2006-07-28 15:28:20 | Re: The vacuum-ignore-vacuum patch |