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

Commit5bb2b6a

Browse files
committed
Temporarily add some probes of tenk1's relallvisible in create_index.sql.
This is to gather some more evidence about why buildfarm member wrasseis failing. We should revert it (or at least scale it way back) oncethat's resolved.Discussion:https://postgr.es/m/1346227.1649887693@sss.pgh.pa.us
1 parent4cd8717 commit5bb2b6a

File tree

2 files changed

+71
-0
lines changed

2 files changed

+71
-0
lines changed

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

Lines changed: 49 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -17,10 +17,45 @@ LINE 1: CREATE INDEX IF NOT EXISTS ON onek USING btree(unique1 int4_...
1717
CREATE INDEX onek_unique2 ON onek USING btree(unique2 int4_ops);
1818
CREATE INDEX onek_hundred ON onek USING btree(hundred int4_ops);
1919
CREATE INDEX onek_stringu1 ON onek USING btree(stringu1 name_ops);
20+
select relallvisible::float8/relpages as visfrac
21+
from pg_class where relname = 'tenk1';
22+
visfrac
23+
---------
24+
1
25+
(1 row)
26+
2027
CREATE INDEX tenk1_unique1 ON tenk1 USING btree(unique1 int4_ops);
28+
select relallvisible::float8/relpages as visfrac
29+
from pg_class where relname = 'tenk1';
30+
visfrac
31+
---------
32+
1
33+
(1 row)
34+
2135
CREATE INDEX tenk1_unique2 ON tenk1 USING btree(unique2 int4_ops);
36+
select relallvisible::float8/relpages as visfrac
37+
from pg_class where relname = 'tenk1';
38+
visfrac
39+
---------
40+
1
41+
(1 row)
42+
2243
CREATE INDEX tenk1_hundred ON tenk1 USING btree(hundred int4_ops);
44+
select relallvisible::float8/relpages as visfrac
45+
from pg_class where relname = 'tenk1';
46+
visfrac
47+
---------
48+
1
49+
(1 row)
50+
2351
CREATE INDEX tenk1_thous_tenthous ON tenk1 (thousand, tenthous);
52+
select relallvisible::float8/relpages as visfrac
53+
from pg_class where relname = 'tenk1';
54+
visfrac
55+
---------
56+
1
57+
(1 row)
58+
2459
CREATE INDEX tenk2_unique1 ON tenk2 USING btree(unique1 int4_ops);
2560
CREATE INDEX tenk2_unique2 ON tenk2 USING btree(unique2 int4_ops);
2661
CREATE INDEX tenk2_hundred ON tenk2 USING btree(hundred int4_ops);
@@ -1216,6 +1251,13 @@ DROP TABLE unlogged_hash_table;
12161251
-- maintenance_work_mem setting and fillfactor:
12171252
SET maintenance_work_mem = '1MB';
12181253
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
1254+
select relallvisible::float8/relpages as visfrac
1255+
from pg_class where relname = 'tenk1';
1256+
visfrac
1257+
---------
1258+
1
1259+
(1 row)
1260+
12191261
EXPLAIN (COSTS OFF)
12201262
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
12211263
QUERY PLAN
@@ -1903,6 +1945,13 @@ SELECT count(*) FROM dupindexcols
19031945
97
19041946
(1 row)
19051947

1948+
select relallvisible::float8/relpages as visfrac
1949+
from pg_class where relname = 'tenk1';
1950+
visfrac
1951+
---------
1952+
1
1953+
(1 row)
1954+
19061955
--
19071956
-- Check ordering of =ANY indexqual results (bug in 9.2.0)
19081957
--

‎src/test/regress/sql/create_index.sql‎

Lines changed: 22 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -21,14 +21,29 @@ CREATE INDEX onek_hundred ON onek USING btree(hundred int4_ops);
2121

2222
CREATEINDEXonek_stringu1ON onek USING btree(stringu1 name_ops);
2323

24+
select relallvisible::float8/relpagesas visfrac
25+
from pg_classwhere relname='tenk1';
26+
2427
CREATEINDEXtenk1_unique1ON tenk1 USING btree(unique1 int4_ops);
2528

29+
select relallvisible::float8/relpagesas visfrac
30+
from pg_classwhere relname='tenk1';
31+
2632
CREATEINDEXtenk1_unique2ON tenk1 USING btree(unique2 int4_ops);
2733

34+
select relallvisible::float8/relpagesas visfrac
35+
from pg_classwhere relname='tenk1';
36+
2837
CREATEINDEXtenk1_hundredON tenk1 USING btree(hundred int4_ops);
2938

39+
select relallvisible::float8/relpagesas visfrac
40+
from pg_classwhere relname='tenk1';
41+
3042
CREATEINDEXtenk1_thous_tenthousON tenk1 (thousand, tenthous);
3143

44+
select relallvisible::float8/relpagesas visfrac
45+
from pg_classwhere relname='tenk1';
46+
3247
CREATEINDEXtenk2_unique1ON tenk2 USING btree(unique1 int4_ops);
3348

3449
CREATEINDEXtenk2_unique2ON tenk2 USING btree(unique2 int4_ops);
@@ -369,6 +384,10 @@ DROP TABLE unlogged_hash_table;
369384
-- maintenance_work_mem setting and fillfactor:
370385
SET maintenance_work_mem='1MB';
371386
CREATEINDEXhash_tuplesort_idxON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor=10);
387+
388+
select relallvisible::float8/relpagesas visfrac
389+
from pg_classwhere relname='tenk1';
390+
372391
EXPLAIN (COSTS OFF)
373392
SELECTcount(*)FROM tenk1WHERE stringu1='TVAAAA';
374393
SELECTcount(*)FROM tenk1WHERE stringu1='TVAAAA';
@@ -746,6 +765,9 @@ EXPLAIN (COSTS OFF)
746765
SELECTcount(*)FROM dupindexcols
747766
WHERE f1 BETWEEN'WA'AND'ZZZ'and id<1000and f1 ~<~'YX';
748767

768+
select relallvisible::float8/relpagesas visfrac
769+
from pg_classwhere relname='tenk1';
770+
749771
--
750772
-- Check ordering of =ANY indexqual results (bug in 9.2.0)
751773
--

0 commit comments

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