pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Christoph Berg <myon@debian.org>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Michael Banck <mbanck@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Nathan Bossart <nathandbossart@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: Set log_lock_waits=on by default
Date: Fri, 19 Jul 2024 15:24:24 +0200
Message-ID: <ZpppCLK1gNs7aXQS@msg.df7cb.de> (raw)
In-Reply-To: <5dc4e037f60467da7bf7d17b10f6ec632a7c9095.camel@cybertec.at>
References: <b8b8502915e50f44deb111bc0b43a99e2733e117.camel@cybertec.at>
	<659ffa38.170a0220.eea6a.28fc@mx.google.com>
	<65b146b9.170a0220.c645b.0891@mx.google.com>
	<20240206165343.GA3841415@nathanxps13>
	<524751.1707240550@sss.pgh.pa.us>
	<6698edb4.5d0a0220.df6fa.5b59@mx.google.com>
	<5dc4e037f60467da7bf7d17b10f6ec632a7c9095.camel@cybertec.at>

Re: Laurenz Albe
> The major criticism is Tom's that it might unduly increase the log volume.
> 
> I'm not trying to rush things, but I see little point in kicking a trivial
> patch like this through many commitfests.  If no committer wants to step
> up and commit this, it should be rejected.

That would be a pity, I still think log_lock_waits=on by default would
be a good thing.

I have not seen any server yet where normal, legitimate operation
would routinely trigger the message. (If it did, people should likely
have used SKIP LOCKED or NOWAIT instead.) It would only increase the
log volume on systems that have a problem.

Christoph

view thread (33+ messages)  latest in thread

Message-ID: <ZpppCLK1gNs7aXQS@msg.df7cb.de>
Permalink:  ../ZpppCLK1gNs7aXQS@msg.df7cb.de/
Also on:    postgresql.org/message-id/ZpppCLK1gNs7aXQS@msg.df7cb.de

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: myon@debian.org, laurenz.albe@cybertec.at, mbanck@gmx.net, tgl@sss.pgh.pa.us, nathandbossart@gmail.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: Set log_lock_waits=on by default
  In-Reply-To: <ZpppCLK1gNs7aXQS@msg.df7cb.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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