Postgres Pro
Downloads
Home   >   mailing lists

Small LO_BUFSIZE slows down lo_import and lo_export in libpq - Mailing list pgsql-hackers

From Дмитрий Питаков
Subject Small LO_BUFSIZE slows down lo_import and lo_export in libpq
Date
Msg-id CAN9_0q6SxObnbEdwwmDON_YqhtH2C75z32wKf1wYWh4cKfbo6Q@mail.gmail.com
Whole thread Raw
Responses Re: Small LO_BUFSIZE slows down lo_import and lo_export in libpq
List pgsql-hackers
Tree view
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?

pgsql-hackers by date:

Previous
From: "Andrey M. Borodin"
Date:
Subject: Re: Allow non-superuser to cancel superuser tasks.
Next
From: jian he
Date:
Subject: Re: minor doc issue in 9.16.2.1.1. Boolean Predicate Check Expressions