blob: 4e5e562b43424ce00d86701eeb23586dcff4bcab (
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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
|
CREATE EXTENSION test_slru;
SELECT test_slru_page_exists(12345);
test_slru_page_exists
-----------------------
f
(1 row)
SELECT test_slru_page_write(12345, 'Test SLRU');
test_slru_page_write
----------------------
(1 row)
SELECT test_slru_page_read(12345);
test_slru_page_read
---------------------
Test SLRU
(1 row)
SELECT test_slru_page_exists(12345);
test_slru_page_exists
-----------------------
t
(1 row)
-- 48 extra pages
SELECT count(test_slru_page_write(a, 'Test SLRU'))
FROM generate_series(12346, 12393, 1) as a;
count
-------
48
(1 row)
-- Reading page in buffer for read and write
SELECT test_slru_page_read(12377, true);
test_slru_page_read
---------------------
Test SLRU
(1 row)
-- Reading page in buffer for read-only
SELECT test_slru_page_readonly(12377);
test_slru_page_readonly
-------------------------
Test SLRU
(1 row)
-- Reading page not in buffer with read-only
SELECT test_slru_page_readonly(12346);
test_slru_page_readonly
-------------------------
Test SLRU
(1 row)
-- Write all the pages in buffers
SELECT test_slru_page_writeall();
test_slru_page_writeall
-------------------------
(1 row)
-- Flush the last page written out.
SELECT test_slru_page_sync(12393);
NOTICE: Called SlruSyncFileTag() for segment 387 on path pg_test_slru/000000000000183
test_slru_page_sync
---------------------
(1 row)
SELECT test_slru_page_exists(12393);
test_slru_page_exists
-----------------------
t
(1 row)
-- Segment deletion
SELECT test_slru_page_delete(12393);
NOTICE: Called SlruDeleteSegment() for segment 387
test_slru_page_delete
-----------------------
(1 row)
SELECT test_slru_page_exists(12393);
test_slru_page_exists
-----------------------
f
(1 row)
-- Page truncation
SELECT test_slru_page_exists(12377);
test_slru_page_exists
-----------------------
t
(1 row)
SELECT test_slru_page_truncate(12377);
test_slru_page_truncate
-------------------------
(1 row)
SELECT test_slru_page_exists(12377);
test_slru_page_exists
-----------------------
t
(1 row)
-- Full deletion
SELECT test_slru_delete_all();
NOTICE: Calling test_slru_scan_cb()
test_slru_delete_all
----------------------
(1 row)
SELECT test_slru_page_exists(12345);
test_slru_page_exists
-----------------------
f
(1 row)
SELECT test_slru_page_exists(12377);
test_slru_page_exists
-----------------------
f
(1 row)
SELECT test_slru_page_exists(12393);
test_slru_page_exists
-----------------------
f
(1 row)
DROP EXTENSION test_slru;
|
