Re: The vacuum-ignore-vacuum patch
| От | Tom Lane |
|---|---|
| Тема | Re: The vacuum-ignore-vacuum patch |
| Дата | |
| Msg-id | 24952.1154102600@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: The vacuum-ignore-vacuum patch (Alvaro Herrera <alvherre@commandprompt.com>) |
| Ответы |
Re: The vacuum-ignore-vacuum patch
|
| Список | pgsql-hackers |
Alvaro Herrera <alvherre@commandprompt.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
В списке pgsql-hackers по дате отправления: