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.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