blob: 6a196cb95c68defa0c45138c57da8a7dede61d59 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
VACUUM;
--
-- sanity check, if we don't have indices the test will take years to
-- complete.
--
SELECT relname, relhasindex
FROM pg_class
WHERE relhasindex
ORDER BY relname;
relname | relhasindex
---------------------+-------------
bt_f8_heap | t
bt_i4_heap | t
bt_name_heap | t
bt_txt_heap | t
fast_emp4000 | t
hash_f8_heap | t
hash_i4_heap | t
hash_name_heap | t
hash_txt_heap | t
ihighway | t
num_exp_add | t
num_exp_div | t
num_exp_ln | t
num_exp_log10 | t
num_exp_mul | t
num_exp_power_10_ln | t
num_exp_sqrt | t
num_exp_sub | t
onek | t
pg_aggregate | t
pg_am | t
pg_amop | t
pg_attrdef | t
pg_attribute | t
pg_class | t
pg_description | t
pg_group | t
pg_index | t
pg_inherits | t
pg_language | t
pg_listener | t
pg_opclass | t
pg_operator | t
pg_proc | t
pg_relcheck | t
pg_rewrite | t
pg_statistic | t
pg_trigger | t
pg_type | t
road | t
shighway | t
tenk1 | t
tenk2 | t
(43 rows)
|
