Database Administrators Asked on December 15, 2020
From what I understand – in a READ_COMMITTED Postgres transaction “the transaction obtains a snapshot whenever an SQL command is executed” source. Does this mean a snapshot will be obtained for each sub query in a nested query? Does the use of CTEs in place of sub queries affect this behavior?
The snapshot 'created' is per statement regardless of whether that statement contains subqueries or not. From the documentation:
... This level is different from Read Committed in that a query in a repeatable read transaction sees a snapshot as of the start of the first non-transaction-control statement in the transaction, not as of the start of the current statement within the transaction.
Answered by nagamocha on December 15, 2020
2 Asked on December 6, 2021 by gryu
1 Asked on December 6, 2021 by j-col
1 Asked on December 6, 2021 by dark-nebula
3 Asked on December 4, 2021 by crthompson
1 Asked on December 4, 2021 by geeves
2 Asked on December 4, 2021 by user162241
2 Asked on December 4, 2021 by purav-desai
2 Asked on December 4, 2021 by littlelebowski
2 Asked on December 2, 2021 by kitchen
1 Asked on December 2, 2021 by cb_ron
1 Asked on November 30, 2021 by magier
1 Asked on November 30, 2021 by teja
1 Asked on November 30, 2021 by mithun-john-jacob
0 Asked on November 30, 2021 by gogofan
2 Asked on November 30, 2021 by carlos-alberto-martinez-martin
3 Asked on November 30, 2021
1 Asked on November 30, 2021
Get help from others!
Recent Answers
Recent Questions
© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP