| blob | c6f1f158ee55cd48471074ac2338a2eff90b7775 |
1 VACUUM;
2 --
3 -- sanity check, if we don't have indices the test will take years to
4 -- complete. But skip TOAST relations (since they will have varying
5 -- names depending on the current OID counter) as well as temp tables
6 -- of other backends (to avoid timing-dependent behavior).
7 --
8 SELECT relname, relhasindex
9 FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = relnamespace
10 WHERE relkind = 'r' AND (nspname ~ '^pg_temp_') IS NOT TRUE
11 ORDER BY relname;
12 relname | relhasindex
13 -------------------------+-------------
14 a | f
15 a_star | f
16 abstime_tbl | f
17 aggtest | f
18 array_index_op_test | t
19 array_op_test | f
20 b | f
21 b_star | f
22 box_tbl | f
23 bprime | f
24 bt_f8_heap | t
25 bt_i4_heap | t
26 bt_name_heap | t
27 bt_txt_heap | t
28 c | f
29 c_star | f
30 char_tbl | f
31 check2_tbl | f
32 check_tbl | f
33 circle_tbl | t
34 city | f
35 copy_tbl | f
36 d | f
37 d_star | f
38 date_tbl | f
39 default_tbl | f
40 defaultexpr_tbl | f
41 dept | f
42 e_star | f
43 emp | f
44 equipment_r | f
45 f_star | f
46 fast_emp4000 | t
47 float4_tbl | f
48 float8_tbl | f
49 func_index_heap | t
50 hash_f8_heap | t
51 hash_i4_heap | t
52 hash_name_heap | t
53 hash_txt_heap | t
54 hobbies_r | f
55 ihighway | t
56 inet_tbl | f
57 inhe | f
58 inhf | f
59 inhx | t
60 insert_tbl | f
61 int2_tbl | f
62 int4_tbl | f
63 int8_tbl | f
64 interval_tbl | f
65 iportaltest | f
66 log_table | f
67 lseg_tbl | f
68 main_table | f
69 money_data | f
70 num_data | f
71 num_exp_add | t
72 num_exp_div | t
73 num_exp_ln | t
74 num_exp_log10 | t
75 num_exp_mul | t
76 num_exp_power_10_ln | t
77 num_exp_sqrt | t
78 num_exp_sub | t
79 num_input_test | f
80 num_result | f
81 onek | t
82 onek2 | t
83 path_tbl | f
84 person | f
85 pg_aggregate | t
86 pg_am | t
87 pg_amop | t
88 pg_amproc | t
89 pg_attrdef | t
90 pg_attribute | t
91 pg_auth_members | t
92 pg_authid | t
93 pg_cast | t
94 pg_class | t
95 pg_constraint | t
96 pg_conversion | t
97 pg_database | t
98 pg_depend | t
99 pg_description | t
100 pg_enum | t
101 pg_foreign_data_wrapper | t
102 pg_foreign_server | t
103 pg_index | t
104 pg_inherits | t
105 pg_language | t
106 pg_largeobject | t
107 pg_listener | f
108 pg_namespace | t
109 pg_opclass | t
110 pg_operator | t
111 pg_opfamily | t
112 pg_pltemplate | t
113 pg_proc | t
114 pg_rewrite | t
115 pg_shdepend | t
116 pg_shdescription | t
117 pg_statistic | t
118 pg_tablespace | t
119 pg_trigger | t
120 pg_ts_config | t
121 pg_ts_config_map | t
122 pg_ts_dict | t
123 pg_ts_parser | t
124 pg_ts_template | t
125 pg_type | t
126 pg_user_mapping | t
127 point_tbl | f
128 polygon_tbl | t
129 ramp | f
130 real_city | f
131 reltime_tbl | f
132 road | t
133 shighway | t
134 slow_emp4000 | f
135 sql_features | f
136 sql_implementation_info | f
137 sql_languages | f
138 sql_packages | f
139 sql_parts | f
140 sql_sizing | f
141 sql_sizing_profiles | f
142 stud_emp | f
143 student | f
144 tenk1 | t
145 tenk2 | t
146 test_tsvector | f
147 text_tbl | f
148 time_tbl | f
149 timestamp_tbl | f
150 timestamptz_tbl | f
151 timetz_tbl | f
152 tinterval_tbl | f
153 varchar_tbl | f
154 (140 rows)
156 --
157 -- another sanity check: every system catalog that has OIDs should have
158 -- a unique index on OID. This ensures that the OIDs will be unique,
159 -- even after the OID counter wraps around.
160 -- We exclude non-system tables from the check by looking at nspname.
161 --
162 SELECT relname, nspname
163 FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = relnamespace
164 WHERE relhasoids
165 AND ((nspname ~ '^pg_') IS NOT FALSE)
166 AND NOT EXISTS (SELECT 1 FROM pg_index i WHERE indrelid = c.oid
167 AND indkey[0] = -2 AND indnatts = 1 AND indisunique);
168 relname | nspname
169 ---------+---------
170 (0 rows)