Message-ID: <5d54261a34994240b7d1bb6861001ec67626f594.camel@cybertec.at>
Subject: Re: Improving insert performance
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: =?UTF-8?Q?=D0=A0=D1=83=D1=81=D0=B8=D0=BD=D0=BE=D0=B2_?=
 =?UTF-8?Q?=D0=A1=D0=B5=D0=BC=D0=B5=D0=BD?=
	 <mrpinkolik@gmail.com>, "pgsql-performance@postgresql.org"
	 <pgsql-performance@postgresql.org>
Date: Mon, 04 May 2026 22:49:33 +0200
In-Reply-To: <c3bbe654-939b-467a-9626-8c0938b7347d@gmail.com>
References: <c3bbe654-939b-467a-9626-8c0938b7347d@gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/5d54261a34994240b7d1bb6861001ec67626f594.camel%40cybertec.at>
Precedence: bulk

On Tue, 2026-05-05 at 00:01 +0500, =D0=A0=D1=83=D1=81=D0=B8=D0=BD=D0=BE=D0=
=B2 =D0=A1=D0=B5=D0=BC=D0=B5=D0=BD wrote:
> I am trying to optimize PostgreSQL for insert performance and I think=20
> I've reaced the limit of my knowledge and experience.
>=20
> So far, I was able to reach RPS of 35k inserts per second. But I can't=
=20
> tune it any better, neither I understand where is the bottleneck.
>=20
> full_page_writes=3Doff
> fsync=3Doff

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=20
> used at full, IO is also not the problem, RAM also seems to be fine. I=
=20
> tried scaling synthetic applications but it doesn't give any RPS boost.=
=20
> So I'm stuck here. Have I reached PostgreSQL performance cap? Or do I=20
> have a bottleneck somewhere else? I don't have any ideas anymore what=20
> 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