Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: Use ctid in where clause in update from statement
Date
Msg-id a4a8a499-5ae5-d35a-107c-7bf7661e2d14@gmx.net
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 schrieb am 01.07.2019 um 12:02:
> 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.
Well, in Postgres  ctid is not necessarily faster.

pgsql-general by date:

Previous
From: Dirk Mika
Date:
Subject: Re: Use ctid in where clause in update from statement
Next
From: Thomas Kellerer
Date:
Subject: Re: Use ctid in where clause in update from statement