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:
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:
Regards,
Frits
