Postgres Pro
Downloads
Home   >   mailing lists

Re: Use ctid in where clause in update from statement - Mailing list pgsql-general

From Tom Lane
Subject Re: Use ctid in where clause in update from statement
Date
Msg-id 27050.1561990779@sss.pgh.pa.us
Whole thread Raw
In response to Re: Use ctid in where clause in update from statement  (Dirk Mika <Dirk.Mika@mikatiming.de>)
List pgsql-general
Tree view 
Dirk Mika <Dirk.Mika@mikatiming.de> writes:
> I know I can join using the pk, but in oracle using the rowid is faster so I wanted to know, if this is possible in
PostgreSQLas well. 

Existing Postgres releases are not very bright about joins on CTID ---
basically merge join is the only plan type you can get for that.
v12 will improve that somewhat.

            regards, tom lane

pgsql-general by date:

Previous
From: Dirk Mika
Date:
Subject: Re: Use ctid in where clause in update from statement
Next
From: Ron
Date:
Subject: Statistics tables not being updated anymore