Re: ctid access is slow

From: "Ilja Golshtein" <ilejn(at)yandex(dot)ru>
To: mike(at)fuhr(dot)org
Cc: xzilla(at)users(dot)sourceforge(dot)net, pgsql-general(at)postgresql(dot)org, ilejn(at)yandex(dot)ru
Subject: Re: ctid access is slow
Date: 2005-08-23 14:02:05
Message-ID: 430B2C5D.000008.17678@mfront7.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emi Lu 2005-08-23 14:30:14 Question about Foreign key constraint causes "costly sequential scans"?
Previous Message Michael Fuhr 2005-08-23 13:47:40 Re: ctid access is slow