Skip to content

Commit 9199853

Browse files
tglsfdctglsfdc
committed
Revert "Temporarily add some probes of tenk1's relallvisible in create_index.sql."
This reverts commit 5bb2b6a. Not needed anymore.
1 parent f7a605f commit 9199853

File tree

2 files changed

+0
-71
lines changed

2 files changed

+0
-71
lines changed

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

Lines changed: 0 additions & 49 deletions
Original file line numberDiff line numberDiff line change
@@ -17,45 +17,10 @@ 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-
2720
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-
3521
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-
4322
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-
5123
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-
5924
CREATE INDEX tenk2_unique1 ON tenk2 USING btree(unique1 int4_ops);
6025
CREATE INDEX tenk2_unique2 ON tenk2 USING btree(unique2 int4_ops);
6126
CREATE INDEX tenk2_hundred ON tenk2 USING btree(hundred int4_ops);
@@ -1251,13 +1216,6 @@ DROP TABLE unlogged_hash_table;
12511216
-- maintenance_work_mem setting and fillfactor:
12521217
SET maintenance_work_mem = '1MB';
12531218
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-
12611219
EXPLAIN (COSTS OFF)
12621220
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
12631221
QUERY PLAN
@@ -1945,13 +1903,6 @@ SELECT count(*) FROM dupindexcols
19451903
97
19461904
(1 row)
19471905

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

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

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

2222
CREATE INDEX onek_stringu1 ON onek USING btree(stringu1 name_ops);
2323

24-
select relallvisible::float8/relpages as visfrac
25-
from pg_class where relname = 'tenk1';
26-
2724
CREATE INDEX tenk1_unique1 ON tenk1 USING btree(unique1 int4_ops);
2825

29-
select relallvisible::float8/relpages as visfrac
30-
from pg_class where relname = 'tenk1';
31-
3226
CREATE INDEX tenk1_unique2 ON tenk1 USING btree(unique2 int4_ops);
3327

34-
select relallvisible::float8/relpages as visfrac
35-
from pg_class where relname = 'tenk1';
36-
3728
CREATE INDEX tenk1_hundred ON tenk1 USING btree(hundred int4_ops);
3829

39-
select relallvisible::float8/relpages as visfrac
40-
from pg_class where relname = 'tenk1';
41-
4230
CREATE INDEX tenk1_thous_tenthous ON tenk1 (thousand, tenthous);
4331

44-
select relallvisible::float8/relpages as visfrac
45-
from pg_class where relname = 'tenk1';
46-
4732
CREATE INDEX tenk2_unique1 ON tenk2 USING btree(unique1 int4_ops);
4833

4934
CREATE INDEX tenk2_unique2 ON tenk2 USING btree(unique2 int4_ops);
@@ -384,10 +369,6 @@ DROP TABLE unlogged_hash_table;
384369
-- maintenance_work_mem setting and fillfactor:
385370
SET maintenance_work_mem = '1MB';
386371
CREATE INDEX hash_tuplesort_idx ON tenk1 USING hash (stringu1 name_ops) WITH (fillfactor = 10);
387-
388-
select relallvisible::float8/relpages as visfrac
389-
from pg_class where relname = 'tenk1';
390-
391372
EXPLAIN (COSTS OFF)
392373
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
393374
SELECT count(*) FROM tenk1 WHERE stringu1 = 'TVAAAA';
@@ -765,9 +746,6 @@ EXPLAIN (COSTS OFF)
765746
SELECT count(*) FROM dupindexcols
766747
WHERE f1 BETWEEN 'WA' AND 'ZZZ' and id < 1000 and f1 ~<~ 'YX';
767748

768-
select relallvisible::float8/relpages as visfrac
769-
from pg_class where relname = 'tenk1';
770-
771749
--
772750
-- Check ordering of =ANY indexqual results (bug in 9.2.0)
773751
--

0 commit comments

Comments
 (0)