3
-- grep 843938989 hash.data
5
SELECT * FROM hash_i4_heap
6
WHERE hash_i4_heap.random = 843938989;
14
-- grep 66766766 hash.data
16
SELECT * FROM hash_i4_heap
17
WHERE hash_i4_heap.random = 66766766;
24
-- grep 1505703298 hash.data
26
SELECT * FROM hash_name_heap
27
WHERE hash_name_heap.random = '1505703298'::name;
35
-- grep 7777777 hash.data
37
SELECT * FROM hash_name_heap
38
WHERE hash_name_heap.random = '7777777'::name;
45
-- grep 1351610853 hash.data
47
SELECT * FROM hash_txt_heap
48
WHERE hash_txt_heap.random = '1351610853'::text;
56
-- grep 111111112222222233333333 hash.data
58
SELECT * FROM hash_txt_heap
59
WHERE hash_txt_heap.random = '111111112222222233333333'::text;
66
-- grep 444705537 hash.data
68
SELECT * FROM hash_f8_heap
69
WHERE hash_f8_heap.random = '444705537'::float8;
77
-- grep 88888888 hash.data
79
SELECT * FROM hash_f8_heap
80
WHERE hash_f8_heap.random = '88888888'::float8;
87
-- grep '^90[^0-9]' hashovfl.data
89
-- SELECT count(*) AS i988 FROM hash_ovfl_heap
93
-- grep '^1000[^0-9]' hashovfl.data
95
-- SELECT count(*) AS i0 FROM hash_ovfl_heap
102
WHERE hash_i4_heap.seqno = 1492;
103
SELECT h.seqno AS i1492, h.random AS i1
113
WHERE hash_i4_heap.random = 1492795354;
114
SELECT h.seqno AS i20000
116
WHERE h.random = 1492795354;
122
UPDATE hash_name_heap
123
SET random = '0123456789abcdef'::name
124
WHERE hash_name_heap.seqno = 6543;
125
SELECT h.seqno AS i6543, h.random AS c0_to_f
126
FROM hash_name_heap h
127
WHERE h.random = '0123456789abcdef'::name;
129
-------+------------------
130
6543 | 0123456789abcdef
133
UPDATE hash_name_heap
135
WHERE hash_name_heap.random = '76652222'::name;
137
-- this is the row we just replaced; index scan should return zero rows
139
SELECT h.seqno AS emptyset
140
FROM hash_name_heap h
141
WHERE h.random = '76652222'::name;
147
SET random = '0123456789abcdefghijklmnop'::text
148
WHERE hash_txt_heap.seqno = 4002;
149
SELECT h.seqno AS i4002, h.random AS c0_to_p
151
WHERE h.random = '0123456789abcdefghijklmnop'::text;
153
-------+----------------------------
154
4002 | 0123456789abcdefghijklmnop
159
WHERE hash_txt_heap.random = '959363399'::text;
160
SELECT h.seqno AS t20000
162
WHERE h.random = '959363399'::text;
169
SET random = '-1234.1234'::float8
170
WHERE hash_f8_heap.seqno = 8906;
171
SELECT h.seqno AS i8096, h.random AS f1234_1234
173
WHERE h.random = '-1234.1234'::float8;
181
WHERE hash_f8_heap.random = '488912369'::float8;
182
SELECT h.seqno AS f20000
184
WHERE h.random = '488912369'::float8;
190
-- UPDATE hash_ovfl_heap
193
-- this vacuums the index as well
194
-- VACUUM hash_ovfl_heap;
195
-- SELECT count(*) AS i0 FROM hash_ovfl_heap
197
-- SELECT count(*) AS i988 FROM hash_ovfl_heap