Search Postgresql Archives

Re: Use ctid in where clause in update from statement

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Use ctid in where clause in update from statement
From: Thomas Kellerer <spam_eater@xxxxxxx>
Date: Mon, 1 Jul 2019 13:25:22 +0200
In-reply-to: <209A99DE-CF4F-47E4-BBDF-530112814475@mikatiming.de>
References: <C8D480EC-AFF2-40CC-8BD3-754A1204011A@mikatiming.de> <d7a5335e-947b-be84-d5c7-11203cb086b8@gmx.net> <209A99DE-CF4F-47E4-BBDF-530112814475@mikatiming.de>
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Use ctid in where clause in update from statement
  - From: Dirk Mika
- Re: Use ctid in where clause in update from statement
  - From: Thomas Kellerer
- Re: Use ctid in where clause in update from statement
  - From: Dirk Mika

Prev by Date: Re: Use ctid in where clause in update from statement
Next by Date: Re: Use ctid in where clause in update from statement
Previous by thread: Re: Use ctid in where clause in update from statement
Next by thread: Re: Use ctid in where clause in update from statement
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux