Re: Improving insert performance

On Tue, 2026-05-05 at 00:01 +0500, Русинов Семен wrote:
> I am trying to optimize PostgreSQL for insert performance and I think
> I've reaced the limit of my knowledge and experience.
>
> So far, I was able to reach RPS of 35k inserts per second. But I can't
> tune it any better, neither I understand where is the bottleneck.
>
> full_page_writes=off
> fsync=off

Don't, unless you don't mind corrupting your database after a crash.

> So I don't see that PostgreSQL is bound to hardware since CPU is not
> used at full, IO is also not the problem, RAM also seems to be fine. I
> tried scaling synthetic applications but it doesn't give any RPS boost.
> So I'm stuck here. Have I reached PostgreSQL performance cap? Or do I
> have a bottleneck somewhere else? I don't have any ideas anymore what
> can I try, I would appreciate any help

How many concurrent sessions are you using?
Monitor pg_stat_activity and see if there are any frequent wait_events.

Yours,
Laurenz Albe