public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Русинов Семен <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Improving insert performance
Date: Mon, 04 May 2026 22:49:33 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Improving insert performance
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox