src/test/modules/test_resowner/sql/test_resowner.sql


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

CREATE EXTENSION test_resowner;

-- This is small enough that everything fits in the small array
SELECT test_resowner_priorities(2, 3);

-- Same test with more resources, to exercise the hash table
SELECT test_resowner_priorities(2, 32);

-- Basic test with lots more resources, to test extending the hash table
SELECT test_resowner_many(
  3,      -- # of different resource kinds
  100000, -- before-locks resources to remember
  500,    -- before-locks resources to forget
  100000, -- after-locks resources to remember
  500     -- after-locks resources to forget
);

-- Test resource leak warning
SELECT test_resowner_leak();

-- Negative tests, using a resource owner after release-phase has started.
set client_min_messages='warning'; -- order between ERROR and NOTICE varies
SELECT test_resowner_remember_between_phases();
SELECT test_resowner_forget_between_phases();
reset client_min_messages;