Slow performance updating CLOB data

From: Nicola Zanaga <NZanaga(at)efsw(dot)it>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Slow performance updating CLOB data
Date: 2016-07-17 09:39:14
Message-ID: 47856758BAE4794A9EC4FCA2E63FC85E37059326@exchange.intranet.efsw.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi, using ResultSet.updateCharacterStream to update a CLOB is very slow.

Most of the time is spent in method PgResultSet.isUpdateable because the table has a primary key but doesn't have a "oid" column.

So the code tries to get primary keys from the query, using getMetaData().getPrimaryKeys.
This is a very slow process.

There is any workaround ?

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Kellerer 2016-07-17 16:42:21 Re: Slow performance updating CLOB data
Previous Message Vladimir Sitnikov 2016-07-15 15:13:11 Re: Possible bug related to primary keys autogeneration