Questions tagged [mvcc]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
2answers
509 views

Is `count(*)` ever guaranteed to return the same result in a transaction at any transaction level?

If I create a table. CREATE TABLE foo AS SELECT CASE WHEN random() > 0.5 THEN x END AS x FROM generate_series(1,10) AS x; And, then I run the following in a transaction BEGIN; SELECT count(*) ...