From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ron Johnson <ronljohnsonjr@gmail.com>
cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Posgresql 14 and CarbonBlack on RHEL8?
In-reply-to: <CANzqJaBybDrzRfjseKPS+3EhBFrLuU_kfSFME_2+VSoR-DLOdw@mail.gmail.com>
References: <CANzqJaBybDrzRfjseKPS+3EhBFrLuU_kfSFME_2+VSoR-DLOdw@mail.gmail.com>
Comments: In-reply-to Ron Johnson <ronljohnsonjr@gmail.com>
	message dated "Tue, 30 Apr 2024 21:21:14 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1854442.1714529264.1@sss.pgh.pa.us>
Date: Tue, 30 Apr 2024 22:07:44 -0400
Message-ID: <1854443.1714529264@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1854443.1714529264%40sss.pgh.pa.us>
Precedence: bulk

Ron Johnson <ronljohnsonjr@gmail.com> writes:
> When running stress tests on the systems (in prod, during the maintenance
> window), 171K events/second are generated on the RHEL8 servers, and CB
> needs (according to top(1)) 325% of CPU to handle that, and still dropping
> 92% of them.
> The RHEL6 system doesn't bat an eye at running the exact same test (36 cron
> jobs running psql executing SELECT statements).

Is JIT enabled on the newer system?  If so try turning it off, or else
raise the associated cost settings.  We've seen lots of reports of
workloads where, by default, the planner is too aggressive about
applying JIT.

			regards, tom lane