contrib/pg_buffercache/expected/pg_buffercache_numa.out


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

SELECT NOT(pg_numa_available()) AS skip_test \gset
\if :skip_test
\quit
\endif
-- We expect at least one entry for each buffer
select count(*) >= (select setting::bigint
                    from pg_settings
                    where name = 'shared_buffers')
from pg_buffercache_numa;
 ?column? 
----------
 t
(1 row)

-- Check that the functions / views can't be accessed by default. To avoid
-- having to create a dedicated user, use the pg_database_owner pseudo-role.
SET ROLE pg_database_owner;
SELECT count(*) > 0 FROM pg_buffercache_numa;
ERROR:  permission denied for view pg_buffercache_numa
RESET role;
-- Check that pg_monitor is allowed to query view / function
SET ROLE pg_monitor;
SELECT count(*) > 0 FROM pg_buffercache_numa;
 ?column? 
----------
 t
(1 row)

RESET role;