pá 3. 4. 2020 v 9:42 odesílatel Jan Strube <Jan.Strube@xxxxxxxxxxxx> napsal:Hi,
we just upgraded our test environment from Postgres 9.4.11 to 12.2. Since then we get out of memory errors that we did not experience before. They happen inside relatively big transactions. We could maybe fix that by splitting them into smaller chunks, but fear that we could run into similar problems when also upgrading on production. We did not change the configuration other than what was necessary for the new version. There are also several Perl triggers on the updated tables, which are triggered inside the transaction. This may well be part of the problem.
Does anyone have an idea what could be the reason for this or how to further investigate?
Maybe there is a combination of recursions and subtransactions ?
Thanks a lot,
Jan
Here is a log extract:
TopMemoryContext: 179080 total in 8 blocks; 17440 free (35 chunks); 161640 used
PL/Perl function: 1024 total in 1 blocks; 376 free (0 chunks); 648 used: set_last_modified
PL/pgSQL function: 32768 total in 3 blocks; 5928 free (5 chunks); 26840 used: fast_export_log()
PL/pgSQL function: 16384 total in 2 blocks; 3464 free (3 chunks); 12920 used: add_third_party_product()
PL/pgSQL function: 32768 total in 3 blocks; 16120 free (3 chunks); 16648 used: set_editor_timestamp()
PL/pgSQL function: 32768 total in 3 blocks; 16040 free (6 chunks); 16728 used: set_editor_timestamp()
PL/Perl function: 1024 total in 1 blocks; 392 free (0 chunks); 632 used: check_category
PL/pgSQL function: 32768 total in 3 blocks; 18048 free (5 chunks); 14720 used: is_leaf(text)
PL/Perl queries: 16384 total in 2 blocks; 6664 free (3 chunks); 9720 used
PL/Perl function: 1024 total in 1 blocks; 320 free (0 chunks); 704 used: is_comment_valid
PL/Perl queries: 16384 total in 2 blocks; 6664 free (3 chunks); 9720 used
PL/Perl function: 1024 total in 1 blocks; 392 free (0 chunks); 632 used: check_category
PL/pgSQL function: 262144 total in 6 blocks; 65816 free (3 chunks); 196328 used: logs.insert_record()
PL/pgSQL function: 16384 total in 2 blocks; 6872 free (5 chunks); 9512 used: update_notation()
PL/Perl function: 1024 total in 1 blocks; 392 free (0 chunks); 632 used: log_changes
PL/Perl function: 1024 total in 1 blocks; 376 free (0 chunks); 648 used: clear_cached_comments
PL/pgSQL function: 32768 total in 3 blocks; 14752 free (3 chunks); 18016 used: cascade_to_ul_country()
PL/pgSQL function: 65536 total in 4 blocks; 34592 free (3 chunks); 30944 used: isin_pz(text)
PLpgSQL cast info: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
PLpgSQL cast cache: 8192 total in 1 blocks; 1584 free (0 chunks); 6608 used
PL/pgSQL function: 16384 total in 2 blocks; 6184 free (6 chunks); 10200 used: isin_ok(text)
Rendezvous variable hash: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
PLpgSQL function hash: 24528 total in 2 blocks; 2624 free (0 chunks); 21904 used
PL/Perl queries: 16384 total in 2 blocks; 6664 free (3 chunks); 9720 used
PL/Perl function: 1024 total in 1 blocks; 376 free (0 chunks); 648 used: set_ul_last_modified
Sequence values: 8192 total in 1 blocks; 1584 free (0 chunks); 6608 used
PL/Perl function: 1024 total in 1 blocks; 392 free (0 chunks); 632 used: sync_log
PL/Perl queries: 16384 total in 2 blocks; 6664 free (3 chunks); 9720 used
PL/Perl function: 1024 total in 1 blocks; 392 free (0 chunks); 632 used: event_log
CFuncHash: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
PL/Perl procedures: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
PL/Perl interpreters: 8192 total in 1 blocks; 2096 free (0 chunks); 6096 used
RI compare cache: 16384 total in 2 blocks; 6664 free (3 chunks); 9720 used
RI query cache: 8192 total in 1 blocks; 1584 free (0 chunks); 6608 used
RI constraint cache: 138976 total in 5 blocks; 2624 free (0 chunks); 136352 used
LocalBufferContext: 8397192 total in 8 blocks; 7936 free (0 chunks); 8389256 used
Local Buffer Lookup Table: 65536 total in 4 blocks; 10312 free (11 chunks); 55224 used
Record information cache: 8192 total in 1 blocks; 1584 free (0 chunks); 6608 used
Btree proof lookup cache: 8192 total in 1 blocks; 560 free (0 chunks); 7632 used
Type information cache: 24352 total in 2 blocks; 2624 free (0 chunks); 21728 used
Prepared Queries: 16384 total in 2 blocks; 6664 free (3 chunks); 9720 used
TableSpace cache: 8192 total in 1 blocks; 2096 free (0 chunks); 6096 used
Operator lookup cache: 24576 total in 2 blocks; 10760 free (3 chunks); 13816 used
TopTransactionContext: 3154168 total in 9 blocks; 33944 free (16 chunks); 3120224 used
SPI Exec: 131072 total in 5 blocks; 63024 free (2 chunks); 68048 used
ExecutorState: 16384 total in 2 blocks; 10120 free (13 chunks); 6264 used
SPI Proc: 8192 total in 1 blocks; 4216 free (10 chunks); 3976 used
SPI Exec: 65536 total in 4 blocks; 688 free (0 chunks); 64848 used
ExecutorState: 147664 total in 6 blocks; 56168 free (8 chunks); 91496 used
AfterTriggerTupleContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
ExprContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
SPI Proc: 8192 total in 1 blocks; 6136 free (4 chunks); 2056 used
MultiXact cache context: 24576 total in 6 blocks; 3640 free (6 chunks); 20936 used
ExecutorState: 131072 total in 5 blocks; 43512 free (4 chunks); 87560 used
AfterTriggerEvents: 16278400 total in 18 blocks; 23240 free (6 chunks); 16255160 used
Combo CIDs: 1048576 total in 8 blocks; 83240 free (16 chunks); 965336 used
CurTransactionContext: 16384 total in 2 blocks; 5688 free (3 chunks); 10696 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 5856 free (0 chunks); 2336 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 16384 total in 2 blocks; 5688 free (3 chunks); 10696 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 16384 total in 2 blocks; 1544 free (2 chunks); 14840 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 16384 total in 2 blocks; 1544 free (2 chunks); 14840 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 5856 free (0 chunks); 2336 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 16384 total in 2 blocks; 5688 free (3 chunks); 10696 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 16384 total in 2 blocks; 5688 free (3 chunks); 10696 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 5856 free (0 chunks); 2336 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 16384 total in 2 blocks; 5688 free (3 chunks); 10696 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 16384 total in 2 blocks; 3624 free (2 chunks); 12760 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 16384 total in 2 blocks; 1544 free (2 chunks); 14840 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7936 free (0 chunks); 256 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
59056 more child contexts containing 677191680 total in 82665 blocks; 647997824 free (0 chunks); 29193856 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
277 more child contexts containing 2269184 total in 277 blocks; 2160600 free (0 chunks); 108584 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
42675 more child contexts containing 349593600 total in 42675 blocks; 332865000 free (0 chunks); 16728600 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
CurTransactionContext: 8192 total in 1 blocks; 7800 free (0 chunks); 392 used
<p c
Hi,
In a 9.x version ? we experienced a postgres memory leak problem that was attributed to using a pl-perl function on a persistent session across myriad transactions.
The solution for us was to re-write the function in pl-python and to periodically drop sessions and reconnect. We did not isolate it down to one or the other. i suspect the reconnect does a good job of memory release by itself.
not sure why it became an issue going from 9.4 to 12 in your case. In any event these are perhaps some things you could try to investigate the matter
Best
Dave
On Fri, Apr 3, 2020 at 07:51 Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:
