Postgres Pro
Downloads
Home   >   mailing lists

very slow largeobject transfers through JDBC - Mailing list pgsql-general

From Mate Varga
Subject very slow largeobject transfers through JDBC
Date
Msg-id CAK4GaZ6+BsNmeiwb=n3NKkrQ-nk51Y0VyVvitUVW602m8dC67w@mail.gmail.com
Whole thread Raw
Responses Re: very slow largeobject transfers through JDBC
List pgsql-general
Tree view
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?

Thanks,
Mate

pgsql-general by date:

Previous
From: Brent Wood
Date:
Subject: Re: Ways to deal with large amount of columns;
Next
From: Dmitry Igrishin
Date:
Subject: Re: very slow largeobject transfers through JDBC