Posgresql 14 and CarbonBlack on RHEL8?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Posgresql 14 and CarbonBlack on RHEL8?
Дата
Msg-id CANzqJaBybDrzRfjseKPS+3EhBFrLuU_kfSFME_2+VSoR-DLOdw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Posgresql 14 and CarbonBlack on RHEL8?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
(CarbonBlack is cross-platform AV software sold by VMware.)

Currently we're running PG 9.6.24 on RHEL 6.10 with CB (version unknown to me) in production, and testing PG 14.11 on RHEL 8.9 with CB 2.15.2 (hopefully going into production next month).

Both old and new VMs are 32 CPU with 128GB RAM.
Nothing but PG, CB and itsm software runs on these systems.

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).

The small RHEL8/PG14 non-prod systems show similar load when lots of SELECT statements run.

Has anyone else seen this?  If so, how did you resolve it?

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Linked directory or explicit reference
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Posgresql 14 and CarbonBlack on RHEL8?