Re: Small LO_BUFSIZE slows down lo_import and lo_export in libpq

2024-06-21 Thread Tom Lane
Jelte Fennema-Nio writes: > On Fri, 21 Jun 2024 at 10:46, Дмитрий Питаков wrote: >> Why not increase the buffer size? > I think changing the buffer size sounds like a reasonable idea, if > that speeds stuff up. But I think it would greatly help your case if > you showed the perf increase using

Re: Small LO_BUFSIZE slows down lo_import and lo_export in libpq

2024-06-21 Thread Jelte Fennema-Nio
On Fri, 21 Jun 2024 at 10:46, Дмитрий Питаков wrote: > Why not increase the buffer size? I think changing the buffer size sounds like a reasonable idea, if that speeds stuff up. But I think it would greatly help your case if you showed the perf increase using a simple benchmark, especially if

Small LO_BUFSIZE slows down lo_import and lo_export in libpq

2024-06-21 Thread Дмитрий Питаков
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