Re: ctid access is slow - Mailing list pgsql-general

From Ilja Golshtein
Subject Re: ctid access is slow
Date
Msg-id 430B2C5D.000008.17678@mfront7.yandex.ru
Whole thread Raw
In response to Re: ctid access is slow  (Michael Fuhr <mike@fuhr.org>)
Responses Re: ctid access is slow  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: ctid access is slow  (Vivek Khera <vivek@khera.org>)
List 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 by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: ctid access is slow
Next
From: Emi Lu
Date:
Subject: Question about Foreign key constraint causes "costly sequential scans"?