Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lmxcP-0002mt-Ey for pgsql-admin@arkaria.postgresql.org; Sat, 29 May 2021 11:59:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lmxcO-0003An-Dk for pgsql-admin@arkaria.postgresql.org; Sat, 29 May 2021 11:59:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lmxcO-0003Af-55 for pgsql-admin@lists.postgresql.org; Sat, 29 May 2021 11:59:04 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lmxcM-00070G-3F for pgsql-admin@lists.postgresql.org; Sat, 29 May 2021 11:59:03 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1lmxcK-0006V3-Sj; Sat, 29 May 2021 07:59:00 -0400 Date: Sat, 29 May 2021 07:59:00 -0400 From: Bruce Momjian To: mustafa.pekgoz@forenda.com.tr Cc: pgsql-admin@lists.postgresql.org Subject: Re: Postgresql SET DEADLOCK_PRIORITY Message-ID: <20210529115900.GA23127@momjian.us> References: <002d01d75481$5b4c9960$11e5cc20$@forenda.com.tr> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <002d01d75481$5b4c9960$11e5cc20$@forenda.com.tr> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, May 29, 2021 at 02:54:18PM +0300, mustafa.pekgoz@forenda.com.tr wrote: > Hello, > > > > Is there any way to set a deadlock priority like MSSQLSERVER command SET > DEADLOCK_PRIORITY? I wan to decide which transaction will be aborted or will be > choosen as a victim. No. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.