pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgresql SET DEADLOCK_PRIORITY
2+ messages / 2 participants
[nested] [flat]

* Postgresql SET DEADLOCK_PRIORITY
@ 2021-05-29 11:54 mustafa.pekgoz@forenda.com.tr
  2021-05-29 11:59 ` Re: Postgresql SET DEADLOCK_PRIORITY Bruce Momjian <bruce@momjian.us>
  0 siblings, 1 reply; 2+ messages in thread

From: mustafa.pekgoz@forenda.com.tr @ 2021-05-29 11:54 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

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.

 

 

Saygýlarýmla.

---

Mustafa Pekgöz
Co-Founder, Principal Database Consultant
Tel : +90 534 429 76 83
E-mail :  <mailto:mustafa.pekgoz@forenda.com.tr>
mustafa.pekgoz@forenda.com.tr
Website:  <http://www.forenda.com.tr/; www.forenda.com.tr
Adres : Barbaros Mah. Begonya Sok. Nidakule No: 1/2 Batý Ataþehir / ÝSTANBUL

                   

 

Attachments:

image003.png (image/png, 2.9K) download view image
image004.jpg (image/jpeg, 3.3K) download view image
^ permalink raw reply [nested|flat] 2+ messages in thread

* Re: Postgresql SET DEADLOCK_PRIORITY
  2021-05-29 11:54 Postgresql SET DEADLOCK_PRIORITY mustafa.pekgoz@forenda.com.tr
@ 2021-05-29 11:59 ` Bruce Momjian <bruce@momjian.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2021-05-29 11:59 UTC (permalink / raw)
  To: mustafa.pekgoz@forenda.com.tr; +Cc: pgsql-admin@lists.postgresql.org

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  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.






^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2021-05-29 11:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-05-29 11:54 Postgresql SET DEADLOCK_PRIORITY mustafa.pekgoz@forenda.com.tr
2021-05-29 11:59 ` Bruce Momjian <bruce@momjian.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox