Optimum size of transaction in Postgres?

Posted by Joe on Stack Overflow See other posts from Stack Overflow or by Joe
Published on 2010-02-24T13:15:28Z Indexed on 2010/04/13 11:02 UTC
Read the original article Hit count: 281

Filed under:
|
|

I'm running a process that does a lot of updates (> 100,000) to a table. I have the choice between putting all the updates in a single transaction or committing transactions every 1000 or so.

Ignore for the moment the case where a transaction fails and is aborted. I'm interested in the best size of transaction for memory and speed efficiency.

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about transaction