Hello Frits,
Would you mind sharing an updated link to your benchmark and source code?
I am also currently tuning postgresql single insert performance for the
outbox pattern. And I'm stuck at 35k inserts per second. However, it
doesn't look like I have reached hardware limit. CPU usage is moderate,
around 20%, RAM is also 20% free. I've tried all sorts of optimizations
but still can't get pass through this RPS, and neither can I understand
what is limiting postgres from inserting at a faster pace.
Best regards,
Simon
On 6/10/17 16:12, Frits Jalvingh wrote:
On Sat, Jun 10, 2017 at 12:08 AM Vladimir Sitnikov
<[email protected]> wrote:
Would you mind sharing the source code of your benchmark?
The source code for the several tests, plus the numbers collected so
far, can be found at:
https://etc.to/confluence/display/~admjal/PostgreSQL+performance+tests
Regards,
Frits
