Re: ctid ranges

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ctid ranges
Дата
Msg-id 16481.1339621210@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ctid ranges  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-general
Bruce Momjian <bruce@momjian.us> writes:
> On Wed, Jun 13, 2012 at 03:21:17PM -0500, Merlin Moncure wrote:
>> IMNSHO, it's a no-brainer for the todo (but I think it's more
>> complicated than adding some comparisons -- which are working now):

> I see.  Seems we have to add index smarts to those comparisons.  That
> might be complicated.

Uh, the whole point of a TID scan is to *not* need an index.

What would be needed is for tidpath.c to let through more kinds of TID
comparison quals than it does now, and then for nodeTidscan.c to know
what to do with them.  The latter logic might well look something like
btree indexscan qual preparation, but it wouldn't be the same code.

            regards, tom lane

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

Предыдущее
От: "Little, Douglas"
Дата:
Сообщение: composite type use in pl/gpsql
Следующее
От: "Gauthier, Dave"
Дата:
Сообщение: Passing master tag around in a multi-site master-slave system