Search Postgresql Archives

Re: Deadlock with one table - PostgreSQL is doing it right

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

Subject: Re: Deadlock with one table - PostgreSQL is doing it right
From: Hans Schou <hans.schou@xxxxxxxxx>
Date: Thu, 21 Dec 2017 21:35:04 +0100
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAMa1XUjPHPWWAJq1uzpN8EA0At8V0tSVfw_fie_uFnd+aqazUA@mail.gmail.com>
References: <CAApBw36hmDPXTN44Fxx=CCgTgf+-iDsBzNOTtnF-QaCfAOSncQ@mail.gmail.com> <CAMa1XUjPHPWWAJq1uzpN8EA0At8V0tSVfw_fie_uFnd+aqazUA@mail.gmail.com>

2017-12-21 17:46 GMT+01:00 Jeremy Finzel <finzelj@xxxxxxxxx>:

It's hard to follow how the 2 videos relate, because you don't run the same SQL both places. You first update where i = 2 in Postgres and i = 1 in Oracle.

Well OK. I made a new one for PostgreSQL: https://youtu.be/En8EFv90yCc

Now with same background color.

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

References:
- Deadlock with one table - PostgreSQL is doing it right
  - From: Hans Schou
- Re: Deadlock with one table - PostgreSQL is doing it right
  - From: Jeremy Finzel

Prev by Date: Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
Next by Date: Re: Deadlock with one table - PostgreSQL is doing it right
Previous by thread: Re: Deadlock with one table - PostgreSQL is doing it right
Next by thread: [no subject]
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