| 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?
| 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 |