From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: Murthy Nunna <mnunna@fnal.gov>,
        "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: psql help
In-reply-to: <CAKFQuwaEb004d7ODhPbFZ+uz724=85pGjR7TNNGGpSoiH1Cb0Q@mail.gmail.com>
References: <DM8PR09MB6677C5B4FDBDFC0F82298DC7B8DE2@DM8PR09MB6677.namprd09.prod.outlook.com> <CAKFQuwaYLtg0W4He0VGfqSTKSj+69sSq_5esqBVTHwSrPfMLmw@mail.gmail.com> <DM8PR09MB66770B55E691C9685E5B5F7BB8DF2@DM8PR09MB6677.namprd09.prod.outlook.com> <CAKFQuwaEb004d7ODhPbFZ+uz724=85pGjR7TNNGGpSoiH1Cb0Q@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Thu, 04 Jul 2024 22:19:35 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <142435.1720157496.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Fri, 05 Jul 2024 01:31:36 -0400
Message-ID: <142436.1720157496@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/142436.1720157496%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thursday, July 4, 2024, Murthy Nunna <mnunna@fnal.gov> wrote:
>> pg_terminate_backend(pid) will not work as it expects only one pid at a
>> time.

> Interesting…I wouldn’t expect the function calls to interact that
> way

TBH, my reaction to that was that the OP doesn't understand SQL
semantics.  As you previously said, simply removing the LIMIT clause
should work fine.  (The ORDER BY looks kinda pointless, too, unless
there are operational constraints we weren't told about.)

There is a question of exactly what "$a'${TIMEOUT_MINS}'$a"
is supposed to mean, but that's independent of the LIMIT issue.

			regards, tom lane