We have a long processing pipeline running on PostgreSQL 9.0.
Is it faster or slower to perform many operations on a single table within one transaction, versus doing auto-commit for each operation?
We're talking in the order of 5 Bulk Inserts and 30 Updates, on one table, querying from other tables. Table rows are in the range of 1-5 million.
We're planning to upgrade to PostgreSQL 9.4 soon. Are there any difference across versions?