mirror of
https://github.com/neondatabase/neon.git
synced 2025-12-22 21:59:59 +00:00
436a117c15
## Problem See https://github.com/neondatabase/neon/issues/12173 ## Summary of changes Allocate table in TopTransactionMemoryContext --------- Co-authored-by: Konstantin Knizhnik <knizhnik@neon.tech>
22 lines
389 B
SQL
22 lines
389 B
SQL
DO $$
|
|
DECLARE
|
|
i numeric;
|
|
BEGIN
|
|
create role somebody;
|
|
FOR i IN 1..1000000 LOOP
|
|
BEGIN
|
|
IF i % 1000 = 0 THEN
|
|
alter role somebody password 'welcome';
|
|
ELSE
|
|
PERFORM 1;
|
|
END IF;
|
|
EXCEPTION WHEN OTHERS THEN
|
|
RAISE WARNING 'error';
|
|
END;
|
|
IF I = 1000000 THEN
|
|
PERFORM pg_log_backend_memory_contexts(pg_backend_pid());
|
|
END IF;
|
|
END LOOP;
|
|
END;
|
|
$$;
|