Dirk Mika <Dirk.Mika@xxxxxxxxxxxxx> 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
