Re: Use ctid in where clause in update from statement

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Use ctid in where clause in update from statement
Date: 2019-07-01 11:25:22
Message-ID: a4a8a499-5ae5-d35a-107c-7bf7661e2d14@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2019-07-01 11:33:06 Re: Use ctid in where clause in update from statement
Previous Message Dirk Mika 2019-07-01 11:18:33 Re: Use ctid in where clause in update from statement