Re: Use ctid in where clause in update from statement

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