Re: ctid access is slow

Поиск
Список
Период
Сортировка
От Ilja Golshtein
Тема Re: ctid access is slow
Дата
Msg-id 430B2C5D.000008.17678@mfront7.yandex.ru
обсуждение исходный текст
Ответ на Re: ctid access is slow  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: ctid access is slow  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: ctid access is slow  (Vivek Khera <vivek@khera.org>)
Список pgsql-general
Hello!

>On Tue, Aug 23, 2005 at 09:15:42AM -0400, Robert Treat wrote:
>> On Tuesday 23 August 2005 08:39, Ilja Golshtein wrote:
>> >
>> > select ctid from aaa where ctid in (select ctid from aaa limit 10);

>Aside from that, ctid is of type tid, and its equality operator
>isn't hashable.

It is the piece of knowledge I failed to deduce exploring
plans of queries ;(.

So I have no better solution then creating indexed
field of serial type, have I?

The only thing I am curios is ctid good for
anything from user point of view?

Thanks a lot.

--
Best regards
Ilja Golshtein

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: ctid access is slow
Следующее
От: Emi Lu
Дата:
Сообщение: Question about Foreign key constraint causes "costly sequential scans"?