From: Дмитрий Питаков <dvpitakov(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject:
Date: 2024-06-17 18:46:51
Message-ID: CAN9_0q6NuQ7ZdqU37WYC43VA4v0GDkH+N9MJcAreGwNYX7F-mw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Browse pgsql-general by date

  From Date Subject
Next Message Maxwell Dreytser 2024-06-18 03:18:40 RowDescription for a function does not include table OID
Previous Message Ron Johnson 2024-06-17 15:57:30 Re: WAL settings for larger imports