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
