MIME-Version: 1.0
From: =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0J/QuNGC0LDQutC+0LI=?= <dvpitakov@gmail.com>
Date: Mon, 17 Jun 2024 21:46:51 +0300
Message-ID: <CAN9_0q6NuQ7ZdqU37WYC43VA4v0GDkH+N9MJcAreGwNYX7F-mw@mail.gmail.com>
Subject: 
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001c0fae061b1a6494"
Archived-At: <https://www.postgresql.org/message-id/CAN9_0q6NuQ7ZdqU37WYC43VA4v0GDkH%2BN9MJcAreGwNYX7F-mw%40mail.gmail.com>
Precedence: bulk

--0000000000001c0fae061b1a6494
Content-Type: text/plain; charset="UTF-8"

In libpq, in the code of the lo_import function, for each piece of a file
of 8KB in size, lo_write is called, which greatly slows down the work of
lo_import because lo_write sends a request and waits for a response.  The
size of 8KB is specified in define LO_BUFSIZE which changed from 1KB to 8KB
24 years ago.
Why not increase the buffer size?

--0000000000001c0fae061b1a6494
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">In libpq, in the code of the lo_import function, for each=
 piece of a file of 8KB in size, lo_write is called, which greatly slows do=
wn the work of lo_import because lo_write sends a request and waits for a r=
esponse.=C2=A0 The size of 8KB is specified in define LO_BUFSIZE which chan=
ged from 1KB to 8KB 24 years ago.=C2=A0<div dir=3D"auto">Why not increase t=
he buffer size?</div></div>

--0000000000001c0fae061b1a6494--