Dirk Mika <dirk.m...@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 PostgreSQL as 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
