Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit56f3468

Browse files
Reduce test variability for toast_tuple_target test
1 parentc251336 commit56f3468

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
Original file line numberDiff line numberDiff line change
@@ -1167,50 +1167,28 @@ SELECT substr(f1, 99995, 10) from toasttest;
11671167
(4 rows)
11681168

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 toasttestvalues (repeat('1234567890',400));
371-
INSERT INTO toasttestvalues (repeat('1234567890',400));
372-
INSERT INTO toasttestvalues (repeat('1234567890',400));
373-
INSERT INTO toasttestvalues (repeat('1234567890',400));
374-
SELECT pg_relation_size('toasttest')/current_setting('block_size')::integeras blocks;
375-
select pg_relation_size('pg_toast.pg_toast_'||(selectoidfrom pg_classwhere relname='toasttest'))/current_setting('block_size')::integeras blocks;
376-
SELECT pg_total_relation_size('toasttest')/current_setting('block_size')::integeras blocks;
370+
INSERT INTO toasttestvalues (repeat('1234567890',300));
371+
INSERT INTO toasttestvalues (repeat('1234567890',300));
372+
INSERT INTO toasttestvalues (repeat('1234567890',300));
373+
INSERT INTO toasttestvalues (repeat('1234567890',300));
374+
-- expect >0 blocks
375+
select0= pg_relation_size('pg_toast.pg_toast_'||(selectoidfrom pg_classwhere relname='toasttest'))/current_setting('block_size')::integeras blocks;
377376

378377
TRUNCATE TABLE toasttest;
379378
ALTERTABLE toasttestset (toast_tuple_target=4080);
380-
INSERT INTO toasttestvalues (repeat('1234567890',400));
381-
INSERT INTO toasttestvalues (repeat('1234567890',400));
382-
INSERT INTO toasttestvalues (repeat('1234567890',400));
383-
INSERT INTO toasttestvalues (repeat('1234567890',400));
384-
SELECT pg_relation_size('toasttest')/current_setting('block_size')::integeras blocks;
385-
select pg_relation_size('pg_toast.pg_toast_'||(selectoidfrom pg_classwhere relname='toasttest'))/current_setting('block_size')::integeras blocks;
386-
SELECT pg_total_relation_size('toasttest')/current_setting('block_size')::integeras blocks;
379+
INSERT INTO toasttestvalues (repeat('1234567890',300));
380+
INSERT INTO toasttestvalues (repeat('1234567890',300));
381+
INSERT INTO toasttestvalues (repeat('1234567890',300));
382+
INSERT INTO toasttestvalues (repeat('1234567890',300));
383+
-- expect 0 blocks
384+
select0= pg_relation_size('pg_toast.pg_toast_'||(selectoidfrom pg_classwhere relname='toasttest'))/current_setting('block_size')::integeras blocks;
387385

388386
DROPTABLE toasttest;
389387

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp