Add skip-empty-xacts option to test_decoding for use in the regression tests.
Andres Freund <andres@anarazel.de>
Add skip-empty-xacts option to test_decoding for use in the regression tests. The regression tests for contrib/test_decoding regularly failed on postgres instances that were very slow. Either because the hardware itself was slow or because very expensive debugging options like CLOBBER_CACHE_ALWAYS were used. The reason they failed was just that some additional transactions were decoded. Analyze and vacuum, triggered by autovac. To fix just add a option to test_decoding to only display transactions in which a change was actually displayed. That's not pretty because it removes information from the tests; but better than constantly failing tests in very likely harmless ways. Backpatch to 9.4 where logical decoding was introduced. Discussion: 20140629142511.GA26930@awork2.anarazel.de
Files
| Path | Change | +/− |
|---|---|---|
| contrib/test_decoding/expected/concurrent_ddl_dml.out | modified | +28 −96 |
| contrib/test_decoding/expected/ddl.out | modified | +21 −59 |
| contrib/test_decoding/expected/decoding_in_xact.out | modified | +3 −5 |
| contrib/test_decoding/expected/permissions.out | modified | +3 −3 |
| contrib/test_decoding/expected/prepared.out | modified | +2 −10 |
| contrib/test_decoding/expected/rewrite.out | modified | +4 −26 |
| contrib/test_decoding/expected/toast.out | modified | +2 −16 |
| contrib/test_decoding/specs/concurrent_ddl_dml.spec | modified | +1 −1 |
| contrib/test_decoding/sql/ddl.sql | modified | +15 −15 |
| contrib/test_decoding/sql/decoding_in_xact.sql | modified | +2 −2 |
| contrib/test_decoding/sql/permissions.sql | modified | +3 −3 |
| contrib/test_decoding/sql/prepared.sql | modified | +1 −1 |
| contrib/test_decoding/sql/rewrite.sql | modified | +2 −2 |
| contrib/test_decoding/sql/toast.sql | modified | +1 −1 |
| contrib/test_decoding/test_decoding.c | modified | +42 −3 |