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 6/10/17 16:12, Frits Jalvingh wrote:
>
> On Sat, Jun 10, 2017 at 12:08 AM Vladimir Sitnikov
> <sitnikov(dot)vladimir(at)gmail(dot)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