I see -- we could try that, though we're mostly using an ORM (Hibernate) to do this. Thanks!
On Fri, Aug 31, 2018 at 3:57 PM Dmitry Igrishin <dmit...@gmail.com> wrote: > пт, 31 авг. 2018 г. в 16:35, Mate Varga <m...@matevarga.net>: > > > > Hi, > > > > we're fetching binary data from pg_largeobject table. The data is not > very large, but we ended up storing it there. If I'm copying the data to a > file from the psql console, then it takes X time (e.g. a second), fetching > it through the JDBC driver takes at least 10x more. We don't see this > difference between JDBC and 'native' performance for anything except > largeobjects (and bytea columns, for the record). > > > > Does anyone have any advice about whether this can be tuned or what the > cause is? > I don't know what a reason of that, but I think it's reasonable and > quite simple to call lo_import()/lo_export() via JNI. >