3 ms·
Not the GP, but I assume transactional consistency was important for the report, hence the need to keep the connection alive. That's a pretty common situation.
by zbentley 7y ago
Not the GP, but I assume transactional consistency was important for the report, hence the need to keep the connection alive. That's a pretty common situation.
- fendy3002 7y agoDoes it means the report take the tables hostage for 30+ minutes? How can transactional consistency be achieved without write lock? Temporary table?
- blattimwind 7y agoMVCC.
- CodesInChaos 7y agoReporting can typically be split into two transactions. One long-running readonly transaction with snapshot consistency obtaining the data for the report and a separate transaction which publishes the result.