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

From Robert Treat
Subject Re: ctid access is slow
Date
Msg-id 200508231829.24755.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: ctid access is slow  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general
On Tuesday 23 August 2005 15:55, Alvaro Herrera wrote:
> On Tue, Aug 23, 2005 at 06:02:05PM +0400, Ilja Golshtein wrote:
> > The only thing I am curios is ctid good for anything from user point
> > of view?
>
> No -- it changes far too frequently for that.

Oh I dunno... In general I'd agree with you, but I've seen a couple of (some
would say hackey) use cases where you use the ctid to iterate over the
columns returned in a row in a plpgsql function...  :-)

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

pgsql-general by date:

Previous
From: Mark Probert
Date:
Subject: [newbie] server startup
Next
From: "Jeff Eckermann"
Date:
Subject: Re: ctid access is slow