Slow performance updating CLOB data - Mailing list pgsql-jdbc

From Nicola Zanaga
Subject Slow performance updating CLOB data
Date
Msg-id 47856758BAE4794A9EC4FCA2E63FC85E37059326@exchange.intranet.efsw.it
Whole thread Raw
Responses Re: Slow performance updating CLOB data  (Thomas Kellerer <spam_eater@gmx.net>)
R: Slow performance updating CLOB data  (Nicola Zanaga <NZanaga@efsw.it>)
List 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 ?

pgsql-jdbc by date:

Previous
From: Nicola Zanaga
Date:
Subject: Slow performance updating CLOB data
Next
From: Thomas Kellerer
Date:
Subject: Re: Slow performance updating CLOB data