/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/modules/test_resowner/sql/test_resowner.sql
25 строк
904 B
Heikki Linnakangas
Make ResourceOwners more easily extensible.
08 ноя 2023, 14:30
08 ноя 2023, 14:30
b8bff07
Код
Авторство
О чём код?
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;