8000 Reduce test variability for toast_tuple_target test · postgrespro/postgres_cluster@56f3468 · GitHub
[go: up one dir, main page]
Skip to content

Commit 56f3468

Browse files
simonat2ndQuadrantsimonat2ndQuadrant
committed
Reduce test variability for toast_tuple_target test
1 parent c251336 commit 56f3468

File tree

2 files changed

+26
-50
lines changed

2 files changed

+26
-50
lines changed

‎src/test/regress/expected/strings.out

Lines changed: 14 additions & 36 deletions
< 8000 td data-grid-cell-id="diff-06b662cd76dd2237cc6f005d46f15228cb37bd625591df322cf0ae6af87bdd03-1168-1168-1" data-selected="false" role="gridcell" style="background-color:var(--bgColor-default);text-align:center" tabindex="-1" valign="top" class="focusable-grid-cell diff-line-number position-relative diff-line-number-neutral left-side">1168
Original file line numberDiff line numberDiff line change
@@ -1167,50 +1167,28 @@ SELECT substr(f1, 99995, 10) from toasttest;
11671167
(4 rows)
1168

11691169
TRUNCATE TABLE toasttest;
1170-
INSERT INTO toasttest values (repeat('1234567890',400));
1171-
INSERT INTO toasttest values (repeat('1234567890',400));
1172-
INSERT INTO toasttest values (repeat('1234567890',400));
1173-
INSERT INTO toasttest values (repeat('1234567890',400));
1174-
SELECT pg_relation_size('toasttest')/current_setting('block_size')::integer as blocks;
1170+
INSERT INTO toasttest values (repeat('1234567890',300));
1171+
INSERT INTO toasttest values (repeat('1234567890',300));
1172+
INSERT INTO toasttest values (repeat('1234567890',300));
1173+
INSERT INTO toasttest values (repeat('1234567890',300));
1174+
-- expect >0 blocks
1175+
select 0 = pg_relation_size('pg_toast.pg_toast_'||(select oid from pg_class where relname = 'toasttest'))/current_setting('block_size')::integer as blocks;
11751176
blocks
11761177
--------
1177-
1
1178-
(1 row)
1179-
1180-
select pg_relation_size('pg_toast.pg_toast_'||(select oid from pg_class where relname = 'toasttest'))/current_setting('block_size')::integer as blocks;
1181-
blocks
1182-
--------
1183-
3
1184-
(1 row)
1185-
1186-
SELECT pg_total_relation_size('toasttest')/current_setting('block_size')::integer as blocks;
1187-
blocks
1188-
--------
1189-
9
1178+
f
11901179
(1 row)
11911180

11921181
TRUNCATE TABLE toasttest;
11931182
ALTER TABLE toasttest set (toast_tuple_target = 4080);
1194-
INSERT INTO toasttest values (repeat('1234567890',400));
1195-
INSERT INTO toasttest values (repeat('1234567890',400));
1196-
INSERT INTO toasttest values (repeat('1234567890',400));
1197-
INSERT INTO toasttest values (repeat('1234567890',400));
1198-
SELECT pg_relation_size('toasttest')/current_setting('block_size')::integer as blocks;
1183+
INSERT INTO toasttest values (repeat('1234567890',300));
1184+
INSERT INTO toasttest values (repeat('1234567890',300));
1185+
INSERT INTO toasttest values (repeat('1234567890',300));
1186+
INSERT INTO toasttest values (repeat('1234567890',300));
1187+
-- expect 0 blocks
1188+
select 0 = pg_relation_size('pg_toast.pg_toast_'||(select oid from pg_class where relname = 'toasttest'))/current_setting('block_size')::integer as blocks;
11991189
blocks
12001190
--------
1201-
2
1202-
(1 row)
1203-
1204-
select pg_relation_size('pg_toast.pg_toast_'||(select oid from pg_class where relname = 'toasttest'))/current_setting('block_size')::integer as blocks;
1205-
blocks
1206-
--------
1207-
0
1208-
(1 row)
1209-
1210-
SELECT pg_total_relation_size('toasttest')/current_setting('block_size')::integer as blocks;
1211-
blocks
1212-
--------
1213-
6
1191+
t
12141192
(1 row)
12151193

12161194
DROP TABLE toasttest;

‎src/test/regress/sql/strings.sql

Lines changed: 12 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -367,23 +367,21 @@ SELECT substr(f1, 99995) from toasttest;
367367
SELECT substr(f1, 99995, 10) from toasttest;
368368

369369
TRUNCATE TABLE toasttest;
370-
INSERT INTO toasttest values (repeat('1234567890',400));
371-
INSERT INTO toasttest values (repeat('1234567890',400));
372-
INSERT INTO toasttest values (repeat('1234567890',400));
373-
INSERT INTO toasttest values (repeat('1234567890',400));
374-
SELECT pg_relation_size('toasttest')/current_setting('block_size')::integer as blocks;
375-
select pg_relation_size('pg_toast.pg_toast_'||(select oid from pg_class where relname = 'toasttest'))/current_setting('block_size')::integer as blocks;
376-
SELECT pg_total_relation_size('toasttest')/current_setting('block_size')::integer as blocks;
370+
INSERT INTO toasttest values (repeat('1234567890',300));
371+
INSERT INTO toasttest values (repeat('1234567890',300));
372+
INSERT INTO toasttest values (repeat('1234567890',300));
373+
INSERT INTO toasttest values (repeat('1234567890',300));
374+
-- expect >0 blocks
375+
select 0 = pg_relation_size('pg_toast.pg_toast_'||(select oid from pg_class where relname = 'toasttest'))/current_setting('block_size')::integer as blocks;
377376

378377
TRUNCATE TABLE toasttest;
379378
ALTER TABLE toasttest set (toast_tuple_target = 4080);
380-
INSERT INTO toasttest values (repeat('1234567890',400));
381-
INSERT INTO toasttest values (repeat('1234567890',400));
382-
INSERT INTO toasttest values (repeat('1234567890',400));
383-
INSERT INTO toasttest values (repeat('1234567890',400));
384-
SELECT pg_relation_size('toasttest')/current_setting('block_size')::integer as blocks;
385-
select pg_relation_size('pg_toast.pg_toast_'||(select oid from pg_class where relname = 'toasttest'))/current_setting('block_size')::integer as blocks;
386-
SELECT pg_total_relation_size('toasttest')/current_setting('block_size')::integer as blocks;
379+
INSERT INTO toasttest values (repeat('1234567890',300));
380+
INSERT INTO toasttest values (repeat('1234567890',300));
381+
INSERT INTO toasttest values (repeat('1234567890',300));
382+
INSERT INTO toasttest values (repeat('1234567890',300));
383+
-- expect 0 blocks
384+
select 0 = pg_relation_size('pg_toast.pg_toast_'||(select oid from pg_class where relname = 'toasttest'))/current_setting('block_size')::integer as blocks;
387385

388386
DROP TABLE toasttest;
389387

0 commit comments

Comments
 (0)
0