From: | Mate Varga <m(at)matevarga(dot)net> |
---|---|
To: | dmitigr(at)gmail(dot)com |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: very slow largeobject transfers through JDBC |
Date: | 2018-08-31 14:15:19 |
Message-ID: | CAK4GaZ7w4yfNCcwcchxJkGc_HC9Pv-s7jzqQh=8t_mV2VqsKCg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <dmitigr(at)gmail(dot)com> wrote:
> пт, 31 авг. 2018 г. в 16:35, Mate Varga <m(at)matevarga(dot)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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2018-08-31 14:17:06 | Re: pg_upgrade fails saying function unaccent(text) doesn't exist |
Previous Message | Adrian Klaver | 2018-08-31 14:14:18 | Re: pg_upgrade fails saying function unaccent(text) doesn't exist |