| -- @Description Insert into a ao relation with 127 concurrent transactions |
| -- |
| DROP TABLE IF EXISTS ao; |
| DROP |
| CREATE TABLE ao (a INT, b INT) USING @amname@; |
| CREATE |
| |
| ALTER RESOURCE GROUP admin_group SET CONCURRENCY 130; |
| ALTER |
| |
| 1: BEGIN; |
| BEGIN |
| 2: BEGIN; |
| BEGIN |
| 3: BEGIN; |
| BEGIN |
| 4: BEGIN; |
| BEGIN |
| 5: BEGIN; |
| BEGIN |
| 6: BEGIN; |
| BEGIN |
| 7: BEGIN; |
| BEGIN |
| 8: BEGIN; |
| BEGIN |
| 9: BEGIN; |
| BEGIN |
| 10: BEGIN; |
| BEGIN |
| 11: BEGIN; |
| BEGIN |
| 12: BEGIN; |
| BEGIN |
| 13: BEGIN; |
| BEGIN |
| 14: BEGIN; |
| BEGIN |
| 15: BEGIN; |
| BEGIN |
| 16: BEGIN; |
| BEGIN |
| 17: BEGIN; |
| BEGIN |
| 18: BEGIN; |
| BEGIN |
| 19: BEGIN; |
| BEGIN |
| 20: BEGIN; |
| BEGIN |
| 21: BEGIN; |
| BEGIN |
| 22: BEGIN; |
| BEGIN |
| 23: BEGIN; |
| BEGIN |
| 24: BEGIN; |
| BEGIN |
| 25: BEGIN; |
| BEGIN |
| 26: BEGIN; |
| BEGIN |
| 27: BEGIN; |
| BEGIN |
| 28: BEGIN; |
| BEGIN |
| 29: BEGIN; |
| BEGIN |
| 30: BEGIN; |
| BEGIN |
| 31: BEGIN; |
| BEGIN |
| 32: BEGIN; |
| BEGIN |
| 33: BEGIN; |
| BEGIN |
| 34: BEGIN; |
| BEGIN |
| 35: BEGIN; |
| BEGIN |
| 36: BEGIN; |
| BEGIN |
| 37: BEGIN; |
| BEGIN |
| 38: BEGIN; |
| BEGIN |
| 39: BEGIN; |
| BEGIN |
| 40: BEGIN; |
| BEGIN |
| 41: BEGIN; |
| BEGIN |
| 42: BEGIN; |
| BEGIN |
| 43: BEGIN; |
| BEGIN |
| 44: BEGIN; |
| BEGIN |
| 45: BEGIN; |
| BEGIN |
| 46: BEGIN; |
| BEGIN |
| 47: BEGIN; |
| BEGIN |
| 48: BEGIN; |
| BEGIN |
| 49: BEGIN; |
| BEGIN |
| 50: BEGIN; |
| BEGIN |
| 51: BEGIN; |
| BEGIN |
| 52: BEGIN; |
| BEGIN |
| 53: BEGIN; |
| BEGIN |
| 54: BEGIN; |
| BEGIN |
| 55: BEGIN; |
| BEGIN |
| 56: BEGIN; |
| BEGIN |
| 57: BEGIN; |
| BEGIN |
| 58: BEGIN; |
| BEGIN |
| 59: BEGIN; |
| BEGIN |
| 60: BEGIN; |
| BEGIN |
| 61: BEGIN; |
| BEGIN |
| 62: BEGIN; |
| BEGIN |
| 63: BEGIN; |
| BEGIN |
| 64: BEGIN; |
| BEGIN |
| 65: BEGIN; |
| BEGIN |
| 66: BEGIN; |
| BEGIN |
| 67: BEGIN; |
| BEGIN |
| 68: BEGIN; |
| BEGIN |
| 69: BEGIN; |
| BEGIN |
| 70: BEGIN; |
| BEGIN |
| 71: BEGIN; |
| BEGIN |
| 72: BEGIN; |
| BEGIN |
| 73: BEGIN; |
| BEGIN |
| 74: BEGIN; |
| BEGIN |
| 75: BEGIN; |
| BEGIN |
| 76: BEGIN; |
| BEGIN |
| 77: BEGIN; |
| BEGIN |
| 78: BEGIN; |
| BEGIN |
| 79: BEGIN; |
| BEGIN |
| 80: BEGIN; |
| BEGIN |
| 81: BEGIN; |
| BEGIN |
| 82: BEGIN; |
| BEGIN |
| 83: BEGIN; |
| BEGIN |
| 84: BEGIN; |
| BEGIN |
| 85: BEGIN; |
| BEGIN |
| 86: BEGIN; |
| BEGIN |
| 87: BEGIN; |
| BEGIN |
| 88: BEGIN; |
| BEGIN |
| 89: BEGIN; |
| BEGIN |
| 90: BEGIN; |
| BEGIN |
| 91: BEGIN; |
| BEGIN |
| 92: BEGIN; |
| BEGIN |
| 93: BEGIN; |
| BEGIN |
| 94: BEGIN; |
| BEGIN |
| 95: BEGIN; |
| BEGIN |
| 96: BEGIN; |
| BEGIN |
| 97: BEGIN; |
| BEGIN |
| 98: BEGIN; |
| BEGIN |
| 99: BEGIN; |
| BEGIN |
| 100: BEGIN; |
| BEGIN |
| 101: BEGIN; |
| BEGIN |
| 102: BEGIN; |
| BEGIN |
| 103: BEGIN; |
| BEGIN |
| 104: BEGIN; |
| BEGIN |
| 105: BEGIN; |
| BEGIN |
| 106: BEGIN; |
| BEGIN |
| 107: BEGIN; |
| BEGIN |
| 108: BEGIN; |
| BEGIN |
| 109: BEGIN; |
| BEGIN |
| 110: BEGIN; |
| BEGIN |
| 111: BEGIN; |
| BEGIN |
| 112: BEGIN; |
| BEGIN |
| 113: BEGIN; |
| BEGIN |
| 114: BEGIN; |
| BEGIN |
| 115: BEGIN; |
| BEGIN |
| 116: BEGIN; |
| BEGIN |
| 117: BEGIN; |
| BEGIN |
| 118: BEGIN; |
| BEGIN |
| 119: BEGIN; |
| BEGIN |
| 120: BEGIN; |
| BEGIN |
| 121: BEGIN; |
| BEGIN |
| 122: BEGIN; |
| BEGIN |
| 123: BEGIN; |
| BEGIN |
| 124: BEGIN; |
| BEGIN |
| 125: BEGIN; |
| BEGIN |
| 126: BEGIN; |
| BEGIN |
| 127: BEGIN; |
| BEGIN |
| 1: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 2: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 3: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 4: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 5: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 6: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 7: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 8: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 9: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 10: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 11: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 12: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 13: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 14: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 15: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 16: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 17: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 18: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 19: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 20: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 21: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 22: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 23: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 24: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 25: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 26: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 27: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 28: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 29: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 30: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 31: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 32: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 33: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 34: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 35: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 36: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 37: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 38: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 39: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 40: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 41: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 42: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 43: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 44: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 45: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 46: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 47: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 48: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 49: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 50: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 51: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 52: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 53: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 54: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 55: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 56: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 57: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 58: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 59: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 60: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 61: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 62: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 63: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 64: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 65: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 66: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 67: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 68: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 69: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 70: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 71: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 72: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 73: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 74: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 75: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 76: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 77: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 78: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 79: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 80: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 81: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 82: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 83: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 84: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 85: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 86: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 87: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 88: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 89: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 90: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 91: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 92: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 93: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 94: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 95: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 96: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 97: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 98: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 99: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 100: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 101: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 102: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 103: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 104: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 105: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 106: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 107: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 108: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 109: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 110: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 111: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 112: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 113: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 114: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 115: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 116: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 117: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 118: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 119: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 120: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 121: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 122: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 123: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 124: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 125: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 126: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 127: INSERT INTO AO VALUES (1, 1); |
| INSERT 1 |
| 1: COMMIT; |
| COMMIT |
| 2: COMMIT; |
| COMMIT |
| 3: COMMIT; |
| COMMIT |
| 4: COMMIT; |
| COMMIT |
| 5: COMMIT; |
| COMMIT |
| 6: COMMIT; |
| COMMIT |
| 7: COMMIT; |
| COMMIT |
| 8: COMMIT; |
| COMMIT |
| 9: COMMIT; |
| COMMIT |
| 10: COMMIT; |
| COMMIT |
| 11: COMMIT; |
| COMMIT |
| 12: COMMIT; |
| COMMIT |
| 13: COMMIT; |
| COMMIT |
| 14: COMMIT; |
| COMMIT |
| 15: COMMIT; |
| COMMIT |
| 16: COMMIT; |
| COMMIT |
| 17: COMMIT; |
| COMMIT |
| 18: COMMIT; |
| COMMIT |
| 19: COMMIT; |
| COMMIT |
| 20: COMMIT; |
| COMMIT |
| 21: COMMIT; |
| COMMIT |
| 22: COMMIT; |
| COMMIT |
| 23: COMMIT; |
| COMMIT |
| 24: COMMIT; |
| COMMIT |
| 25: COMMIT; |
| COMMIT |
| 26: COMMIT; |
| COMMIT |
| 27: COMMIT; |
| COMMIT |
| 28: COMMIT; |
| COMMIT |
| 29: COMMIT; |
| COMMIT |
| 30: COMMIT; |
| COMMIT |
| 31: COMMIT; |
| COMMIT |
| 32: COMMIT; |
| COMMIT |
| 33: COMMIT; |
| COMMIT |
| 34: COMMIT; |
| COMMIT |
| 35: COMMIT; |
| COMMIT |
| 36: COMMIT; |
| COMMIT |
| 37: COMMIT; |
| COMMIT |
| 38: COMMIT; |
| COMMIT |
| 39: COMMIT; |
| COMMIT |
| 40: COMMIT; |
| COMMIT |
| 41: COMMIT; |
| COMMIT |
| 42: COMMIT; |
| COMMIT |
| 43: COMMIT; |
| COMMIT |
| 44: COMMIT; |
| COMMIT |
| 45: COMMIT; |
| COMMIT |
| 46: COMMIT; |
| COMMIT |
| 47: COMMIT; |
| COMMIT |
| 48: COMMIT; |
| COMMIT |
| 49: COMMIT; |
| COMMIT |
| 50: COMMIT; |
| COMMIT |
| 51: COMMIT; |
| COMMIT |
| 52: COMMIT; |
| COMMIT |
| 53: COMMIT; |
| COMMIT |
| 54: COMMIT; |
| COMMIT |
| 55: COMMIT; |
| COMMIT |
| 56: COMMIT; |
| COMMIT |
| 57: COMMIT; |
| COMMIT |
| 58: COMMIT; |
| COMMIT |
| 59: COMMIT; |
| COMMIT |
| 60: COMMIT; |
| COMMIT |
| 61: COMMIT; |
| COMMIT |
| 62: COMMIT; |
| COMMIT |
| 63: COMMIT; |
| COMMIT |
| 64: COMMIT; |
| COMMIT |
| 65: COMMIT; |
| COMMIT |
| 66: COMMIT; |
| COMMIT |
| 67: COMMIT; |
| COMMIT |
| 68: COMMIT; |
| COMMIT |
| 69: COMMIT; |
| COMMIT |
| 70: COMMIT; |
| COMMIT |
| 71: COMMIT; |
| COMMIT |
| 72: COMMIT; |
| COMMIT |
| 73: COMMIT; |
| COMMIT |
| 74: COMMIT; |
| COMMIT |
| 75: COMMIT; |
| COMMIT |
| 76: COMMIT; |
| COMMIT |
| 77: COMMIT; |
| COMMIT |
| 78: COMMIT; |
| COMMIT |
| 79: COMMIT; |
| COMMIT |
| 80: COMMIT; |
| COMMIT |
| 81: COMMIT; |
| COMMIT |
| 82: COMMIT; |
| COMMIT |
| 83: COMMIT; |
| COMMIT |
| 84: COMMIT; |
| COMMIT |
| 85: COMMIT; |
| COMMIT |
| 86: COMMIT; |
| COMMIT |
| 87: COMMIT; |
| COMMIT |
| 88: COMMIT; |
| COMMIT |
| 89: COMMIT; |
| COMMIT |
| 90: COMMIT; |
| COMMIT |
| 91: COMMIT; |
| COMMIT |
| 92: COMMIT; |
| COMMIT |
| 93: COMMIT; |
| COMMIT |
| 94: COMMIT; |
| COMMIT |
| 95: COMMIT; |
| COMMIT |
| 96: COMMIT; |
| COMMIT |
| 97: COMMIT; |
| COMMIT |
| 98: COMMIT; |
| COMMIT |
| 99: COMMIT; |
| COMMIT |
| 100: COMMIT; |
| COMMIT |
| 101: COMMIT; |
| COMMIT |
| 102: COMMIT; |
| COMMIT |
| 103: COMMIT; |
| COMMIT |
| 104: COMMIT; |
| COMMIT |
| 105: COMMIT; |
| COMMIT |
| 106: COMMIT; |
| COMMIT |
| 107: COMMIT; |
| COMMIT |
| 108: COMMIT; |
| COMMIT |
| 109: COMMIT; |
| COMMIT |
| 110: COMMIT; |
| COMMIT |
| 111: COMMIT; |
| COMMIT |
| 112: COMMIT; |
| COMMIT |
| 113: COMMIT; |
| COMMIT |
| 114: COMMIT; |
| COMMIT |
| 115: COMMIT; |
| COMMIT |
| 116: COMMIT; |
| COMMIT |
| 117: COMMIT; |
| COMMIT |
| 118: COMMIT; |
| COMMIT |
| 119: COMMIT; |
| COMMIT |
| 120: COMMIT; |
| COMMIT |
| 121: COMMIT; |
| COMMIT |
| 122: COMMIT; |
| COMMIT |
| 123: COMMIT; |
| COMMIT |
| 124: COMMIT; |
| COMMIT |
| 125: COMMIT; |
| COMMIT |
| 126: COMMIT; |
| COMMIT |
| 127: COMMIT; |
| COMMIT |
| SELECT * FROM ao; |
| a | b |
| ---+--- |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
| (127 rows) |
| SELECT * FROM gp_ao_or_aocs_seg('ao') ORDER BY segno; |
| segment_id | segno | tupcount | modcount | formatversion | state |
| ------------+-------+----------+----------+---------------+------- |
| -1 | 0 | 1 | 1 | 3 | 1 |
| -1 | 1 | 1 | 1 | 3 | 1 |
| -1 | 2 | 1 | 1 | 3 | 1 |
| -1 | 3 | 1 | 1 | 3 | 1 |
| -1 | 4 | 1 | 1 | 3 | 1 |
| -1 | 5 | 1 | 1 | 3 | 1 |
| -1 | 6 | 1 | 1 | 3 | 1 |
| -1 | 7 | 1 | 1 | 3 | 1 |
| -1 | 8 | 1 | 1 | 3 | 1 |
| -1 | 9 | 1 | 1 | 3 | 1 |
| -1 | 10 | 1 | 1 | 3 | 1 |
| -1 | 11 | 1 | 1 | 3 | 1 |
| -1 | 12 | 1 | 1 | 3 | 1 |
| -1 | 13 | 1 | 1 | 3 | 1 |
| -1 | 14 | 1 | 1 | 3 | 1 |
| -1 | 15 | 1 | 1 | 3 | 1 |
| -1 | 16 | 1 | 1 | 3 | 1 |
| -1 | 17 | 1 | 1 | 3 | 1 |
| -1 | 18 | 1 | 1 | 3 | 1 |
| -1 | 19 | 1 | 1 | 3 | 1 |
| -1 | 20 | 1 | 1 | 3 | 1 |
| -1 | 21 | 1 | 1 | 3 | 1 |
| -1 | 22 | 1 | 1 | 3 | 1 |
| -1 | 23 | 1 | 1 | 3 | 1 |
| -1 | 24 | 1 | 1 | 3 | 1 |
| -1 | 25 | 1 | 1 | 3 | 1 |
| -1 | 26 | 1 | 1 | 3 | 1 |
| -1 | 27 | 1 | 1 | 3 | 1 |
| -1 | 28 | 1 | 1 | 3 | 1 |
| -1 | 29 | 1 | 1 | 3 | 1 |
| -1 | 30 | 1 | 1 | 3 | 1 |
| -1 | 31 | 1 | 1 | 3 | 1 |
| -1 | 32 | 1 | 1 | 3 | 1 |
| -1 | 33 | 1 | 1 | 3 | 1 |
| -1 | 34 | 1 | 1 | 3 | 1 |
| -1 | 35 | 1 | 1 | 3 | 1 |
| -1 | 36 | 1 | 1 | 3 | 1 |
| -1 | 37 | 1 | 1 | 3 | 1 |
| -1 | 38 | 1 | 1 | 3 | 1 |
| -1 | 39 | 1 | 1 | 3 | 1 |
| -1 | 40 | 1 | 1 | 3 | 1 |
| -1 | 41 | 1 | 1 | 3 | 1 |
| -1 | 42 | 1 | 1 | 3 | 1 |
| -1 | 43 | 1 | 1 | 3 | 1 |
| -1 | 44 | 1 | 1 | 3 | 1 |
| -1 | 45 | 1 | 1 | 3 | 1 |
| -1 | 46 | 1 | 1 | 3 | 1 |
| -1 | 47 | 1 | 1 | 3 | 1 |
| -1 | 48 | 1 | 1 | 3 | 1 |
| -1 | 49 | 1 | 1 | 3 | 1 |
| -1 | 50 | 1 | 1 | 3 | 1 |
| -1 | 51 | 1 | 1 | 3 | 1 |
| -1 | 52 | 1 | 1 | 3 | 1 |
| -1 | 53 | 1 | 1 | 3 | 1 |
| -1 | 54 | 1 | 1 | 3 | 1 |
| -1 | 55 | 1 | 1 | 3 | 1 |
| -1 | 56 | 1 | 1 | 3 | 1 |
| -1 | 57 | 1 | 1 | 3 | 1 |
| -1 | 58 | 1 | 1 | 3 | 1 |
| -1 | 59 | 1 | 1 | 3 | 1 |
| -1 | 60 | 1 | 1 | 3 | 1 |
| -1 | 61 | 1 | 1 | 3 | 1 |
| -1 | 62 | 1 | 1 | 3 | 1 |
| -1 | 63 | 1 | 1 | 3 | 1 |
| -1 | 64 | 1 | 1 | 3 | 1 |
| -1 | 65 | 1 | 1 | 3 | 1 |
| -1 | 66 | 1 | 1 | 3 | 1 |
| -1 | 67 | 1 | 1 | 3 | 1 |
| -1 | 68 | 1 | 1 | 3 | 1 |
| -1 | 69 | 1 | 1 | 3 | 1 |
| -1 | 70 | 1 | 1 | 3 | 1 |
| -1 | 71 | 1 | 1 | 3 | 1 |
| -1 | 72 | 1 | 1 | 3 | 1 |
| -1 | 73 | 1 | 1 | 3 | 1 |
| -1 | 74 | 1 | 1 | 3 | 1 |
| -1 | 75 | 1 | 1 | 3 | 1 |
| -1 | 76 | 1 | 1 | 3 | 1 |
| -1 | 77 | 1 | 1 | 3 | 1 |
| -1 | 78 | 1 | 1 | 3 | 1 |
| -1 | 79 | 1 | 1 | 3 | 1 |
| -1 | 80 | 1 | 1 | 3 | 1 |
| -1 | 81 | 1 | 1 | 3 | 1 |
| -1 | 82 | 1 | 1 | 3 | 1 |
| -1 | 83 | 1 | 1 | 3 | 1 |
| -1 | 84 | 1 | 1 | 3 | 1 |
| -1 | 85 | 1 | 1 | 3 | 1 |
| -1 | 86 | 1 | 1 | 3 | 1 |
| -1 | 87 | 1 | 1 | 3 | 1 |
| -1 | 88 | 1 | 1 | 3 | 1 |
| -1 | 89 | 1 | 1 | 3 | 1 |
| -1 | 90 | 1 | 1 | 3 | 1 |
| -1 | 91 | 1 | 1 | 3 | 1 |
| -1 | 92 | 1 | 1 | 3 | 1 |
| -1 | 93 | 1 | 1 | 3 | 1 |
| -1 | 94 | 1 | 1 | 3 | 1 |
| -1 | 95 | 1 | 1 | 3 | 1 |
| -1 | 96 | 1 | 1 | 3 | 1 |
| -1 | 97 | 1 | 1 | 3 | 1 |
| -1 | 98 | 1 | 1 | 3 | 1 |
| -1 | 99 | 1 | 1 | 3 | 1 |
| -1 | 100 | 1 | 1 | 3 | 1 |
| -1 | 101 | 1 | 1 | 3 | 1 |
| -1 | 102 | 1 | 1 | 3 | 1 |
| -1 | 103 | 1 | 1 | 3 | 1 |
| -1 | 104 | 1 | 1 | 3 | 1 |
| -1 | 105 | 1 | 1 | 3 | 1 |
| -1 | 106 | 1 | 1 | 3 | 1 |
| -1 | 107 | 1 | 1 | 3 | 1 |
| -1 | 108 | 1 | 1 | 3 | 1 |
| -1 | 109 | 1 | 1 | 3 | 1 |
| -1 | 110 | 1 | 1 | 3 | 1 |
| -1 | 111 | 1 | 1 | 3 | 1 |
| -1 | 112 | 1 | 1 | 3 | 1 |
| -1 | 113 | 1 | 1 | 3 | 1 |
| -1 | 114 | 1 | 1 | 3 | 1 |
| -1 | 115 | 1 | 1 | 3 | 1 |
| -1 | 116 | 1 | 1 | 3 | 1 |
| -1 | 117 | 1 | 1 | 3 | 1 |
| -1 | 118 | 1 | 1 | 3 | 1 |
| -1 | 119 | 1 | 1 | 3 | 1 |
| -1 | 120 | 1 | 1 | 3 | 1 |
| -1 | 121 | 1 | 1 | 3 | 1 |
| -1 | 122 | 1 | 1 | 3 | 1 |
| -1 | 123 | 1 | 1 | 3 | 1 |
| -1 | 124 | 1 | 1 | 3 | 1 |
| -1 | 125 | 1 | 1 | 3 | 1 |
| -1 | 126 | 1 | 1 | 3 | 1 |
| (127 rows) |
| |
| ALTER RESOURCE GROUP admin_group SET CONCURRENCY 20; |
| ALTER |