From: Ronan Dunklau <ronan.dunklau@aiven.io>
To: Noah Misch <noah@leadboat.com>
Cc: Michael Paquier <michael@paquier.xyz>,
 pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Subject: Re: FSM Corruption (was: Could not read block at end of the relation)
Date: Fri, 29 Mar 2024 09:47:52 +0100
Message-ID: <6055942.lOV4Wx5bFT@aivenlaptop>
In-Reply-To: <2493745.irdbgypaU6@aivenlaptop>
References: 
 <VtPLBUerbMM8BSDLQwIMV9Co_38iHS1TXE4V09x2ZVFhPkZMNE8LwgPSIzB8PHkVFXykGx04QNAzZVjJFAnU1w==@protonmail.internalid>
 <20240316045834.83@rfd.leadboat.com> <2493745.irdbgypaU6@aivenlaptop>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="utf-8"
Archived-At: 
 <https://www.postgresql.org/message-id/6055942.lOV4Wx5bFT%40aivenlaptop>
Precedence: bulk

Le jeudi 21 mars 2024, 14:51:25 CET Ronan Dunklau a =C3=A9crit :
> Le samedi 16 mars 2024, 05:58:34 CET Noah Misch a =C3=A9crit :
> > > - Get profiles with both master and patched.  (lseek or freespace.c
> > > functions>
> > >=20
> > >   rising by 0.1%-1% would fit what we know.)

Running perf during the same benchmark, I get the following samples for lse=
ek:

With the patch:

   0.02%  postgres  libc.so.6          [.] llseek@GLIBC_2.2.5=20

Without the patch:

   0.01%  postgres  libc.so.6          [.] llseek@GLIBC_2.2.5


So nothing too dramatic.
I haven't been able to come up with  a better benchmark.

Regards,

=2D-
Ronan