On 20.04.2006, at 18:10 Uhr, Radovan Antloga wrote:

I have once or twice a month update on many records (~6000) but
not so many. I did not expect PG would have problems with
updating 15800 records.

It has no problems with that. We have a database where we often update/insert rows with about one hundred columns. No problem so far. Performance is in the sub 10ms range. The whole table has about 100000 records.

Do you wrap every update in a separate transaction? I do commits every 200 updates for bulk updates.

cug

--
PharmaLine, Essen, GERMANY
Software and Database Development


Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to