Thread: pgsql: pgstat: fix stats.spec instability on slow machines.

pgsql: pgstat: fix stats.spec instability on slow machines.

From
Andres Freund
Date:
pgstat: fix stats.spec instability on slow machines.

On slow machines the modified test could end up switching the order in which
transactional stats are reported in one session and non-transactional stats in
another session. As stats handling of truncate is implemented as setting
live/dead rows 0, the order in which a truncate's stats changes are applied,
relative to normal stats updates, matters. The handling of stats for truncate
hasn't changed due to shared memory stats, this is longstanding behavior.

We might want to improve truncate's stats handling in the future, but for now
just change the order of forced flushed to make the test stable.

Reported-By: Christoph Berg <myon@debian.org>
Discussion: https://postgr.es/m/YoZf7U/WmfmFYFEx@msg.df7cb.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/7fdbdf204920ac279f280d0a8e96946fdaf41aef

Modified Files
--------------
src/test/isolation/expected/stats.out   | 4 ++--
src/test/isolation/expected/stats_1.out | 6 +++---
src/test/isolation/specs/stats.spec     | 3 ++-
3 files changed, 7 insertions(+), 6 deletions(-)