Re: release notes: tids & self-joins

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: release notes: tids & self-joins
Дата
Msg-id 19130.1560460788@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: release notes: tids & self-joins  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-hackers
David Rowley <david.rowley@2ndquadrant.com> writes:
> On Fri, 14 Jun 2019 at 05:22, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Robert Haas <robertmhaas@gmail.com> writes:
>>> So I think that this should probably be changed to say something like
>>> "Improve optimization of self-joins on ctid columns" or "Improve
>>> optimization of joins involving columns of type tid."

>> The latter seems fine to me.

> The latter seems a bit inaccurate to me given the fact that a column
> with the type tid could exist elsewhere in the table.  Perhaps
> "columns of type tid" can be swapped with "a table's ctid column".

It's true that the parameterized-tidscan patch only helps for joins
to CTID, but the other patch helps for joins to any tid column.
So I still say Robert's wording is fine.

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: release notes: tids & self-joins
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: upgrades in row-level locks can deadlock