Re: Improving PostgreSQL insert performance

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 Sat, Jun 10, 2017 at 12:08 AM Vladimir Sitnikov <sitnikov.vladimir@gmail.com> 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