Re: A new function to wait for the backend exit after termination
Justin Pryzby <pryzby@telsasoft.com>
From: Justin Pryzby <pryzby@telsasoft.com>
To: Noah Misch <noah@leadboat.com>
Cc: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>, Magnus Hagander <magnus@hagander.net>, Fujii Masao <masao.fujii@oss.nttdata.com>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, "Hou, Zhijie" <houzj.fnst@cn.fujitsu.com>, pgsql-hackers@lists.postgresql.org, Muhammad Usama <m.usama@gmail.com>
Date: 2021-06-12T05:12:12Z
Lists: pgsql-hackers
On Fri, Jun 11, 2021 at 09:37:50PM -0700, Noah Misch wrote:
> On Fri, Jun 11, 2021 at 08:54:08PM -0500, Justin Pryzby wrote:
> > On Sat, Jun 05, 2021 at 12:08:01PM -0700, Noah Misch wrote:
> > > > > My preference is to remove pg_wait_for_backend_termination(). The use case
> > > > > that prompted this thread used pg_terminate_backend(pid, 180000); it doesn't
> > > > > need pg_wait_for_backend_termination().
> >
> > Is this an Opened Issue ?
>
> An Open Item? Not really, since there's no objective defect. Nonetheless,
> the attached is what I'd like to use.
I think of this as a list of stuff to avoid forgetting that needs to be
addressed or settled before the release.
If the value of the new function is marginal, it may be good to remove it, else
we're committed to supporting it.
Even if it's not removed, the descriptions should be cleaned up.
| src/include/catalog/pg_proc.dat- descr => 'terminate a backend process and if timeout is specified, wait for its exit or until timeout occurs',
=> I think doesn't need to change or mention the optional timeout at all
| src/include/catalog/pg_proc.dat-{ oid => '2137', descr => 'wait for a backend process exit or timeout occurs',
=> should just say "wait for a backend process to exit". The timeout has a default.
Commits
-
Copy-edit text for the pg_terminate_backend() "timeout" parameter.
- 0aac73e6a260 14.0 landed
-
Remove pg_wait_for_backend_termination().
- 5f1df62a459b 14.0 landed
-
Add functions to wait for backend termination
- aaf043257205 14.0 landed
-
Fix typo in comment.
- 6742e14959a3 14.0 cited