Challenges with multithreaded server

Sten-Erik Björling s-e.bjorling at
Mon Feb 13 09:36:12 UTC 2023

Dear all,

Testing performance on a multi-threading server using session pools, and I have some problems.

Using the test database, I use Apache Bench against a server on my machine, and the load is very high for about 4-5 seconds, after which the load gets down 50% (at the 3000 - 4000 call mark, 20 parallel calls) and keeps that level until the test run is done. All the expected sessions get activated from the start, but somewhere a threshold is reached.

I tried to find any parameters or settings on the Omnis side but to no avail, and now I am looking into PostgreSQL side of things. Any recommendations for any one of them?

Take care, all the best…


Sten-Erik Björling
Enviro Data
Kyrkogatan 5A 2 tr
SE-972 32  Luleå

E-Mail: s-e.bjorling at
Mobile: +46-70-655 11 72
Wire: @stenerikbjorling
Skype: stenerikbjorling
iChat: stene at
Signal: +46 70 655 11 72
FaceTime: stene at
Telegram: @stenerikbjorling
Hotmail / Messenger: stenerikbjorling at
GMail: stenerikbjorling at

This email and any files transmitted with it are confidential, may be legally privileged and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please note that any use, distribution, or reproduction of the contents of this email is strictly prohibited and may be unlawful. If you are not the intended recipient, please notify the sender by return email and destroy all copies of the original message including any attachments thereto. Thank you.

Please note that we take reasonable precautions to prevent the transmission of viruses; however, we cannot guarantee that this email or its attachments are free from viruses. We only send and receive emails on the basis that we are not be liable for any loss or damage resulting from the opening of this message and/or attachments.

More information about the omnisdev-en mailing list