Pessoal, Tem como analisar o motivo do "out of memory" com o despejo que aparece no log? O estranho é que quando ele aparece nem entrei ainda no swap e tenho vários buffers livres (free -m). Estou com a versão 9.1.9 Máquina: 8 cores, 32GB, 6GB shared_buffers, 20MB work_mem. Isso ocorre mais quando tenho muitos processos "idle in transaction", mas não obrigatoriamente.
Detail: Failed on request of size 40. Statement: select distinct classejudi0_.id_classe_judicial as id1_291_0_, classejudi1_.id_classe_judicial as id1_291_1_, classejudi0_.in_ativo as in2_291_0_, classejudi0_.ds_classe_judicial as ds3_291_0_, classejudi0_.id_classe_judicial_pai as id36_291_0_, classejudi0_.ds_classe_judicial_sigla as ds6_291_0_, classejudi0_.cd_classe_judicial as cd7_291_0_, classejudi0_.cd_classe_outro as cd8_291_0_, classejudi0_.in_complementar as in9_291_0_, classejudi0_.in_controla_valor_causa as in10_291_0_, classejudi0_.in_designa_aud_errovc as in11_291_0_, classejudi0_.in_exige_autoridade as in12_291_0_, classejudi0_.in_exige_numeracao_propria as in13_291_0_, classejudi0_.id_fluxo as id37_291_0_, classejudi0_.ds_icone as ds14_291_0_, classejudi0_.in_ignora_compensacao as in15_291_0_, classejudi0_.in_ignora_prevencao as in16_291_0_, classejudi0_.in_incidental as in17_291_0_, classejudi0_.in_inicial as in18_291_0_, classejudi0_.in_jus_postulandi as in19_291_0_, classejudi0_.ds_mensagem as ds22_291_0_, classejudi0_.ds_natureza as ds23_291_0_, classejudi0_.ds_norma as ds24_291_0_, classejudi0_.in_exige_pauta as in25_291_0_, classejudi0_.nr_piso_valor_causa as nr26_291_0_, classejudi0_.id_polo_ativo as id38_291_0_, classejudi0_.id_polo_passivo as id39_291_0_, classejudi0_.in_possui_custa as in27_291_0_, classejudi0_.in_possui_filhos as in28_291_0_, classejudi0_.tp_processo_referencia as tp29_291_0_, classejudi0_.in_reclama_polo_passivo as in30_291_0_, classejudi0_.in_recursal as in31_291_0_, classejudi0_.in_exige_revisor as in32_291_0_, classejudi0_.in_segredo_justica as in33_291_0_, classejudi0_.nr_teto_valor_causa as nr34_291_0_, classejudi0_.id_tipo_audiencia as id40_291_0_, classejudi0_.vl_peso as vl35_291_0_, classejudi1_.in_ativo as in2_291_1_, classejudi1_.ds_classe_judicial as ds3_291_1_, classejudi1_.id_classe_judicial_pai as id36_291_1_, classejudi1_.ds_classe_judicial_sigla as ds6_291_1_, classejudi1_.cd_classe_judicial as cd7_291_1_, classejudi1_.cd_classe_outro as cd8_291_1_, classejudi1_.in_complementar as in9_291_1_, classejudi1_.in_controla_valor_causa as in10_291_1_, classejudi1_.in_designa_aud_errovc as in11_291_1_, classejudi1_.in_exige_autoridade as in12_291_1_, classejudi1_.in_exige_numeracao_propria as in13_291_1_, classejudi1_.id_fluxo as id37_291_1_, classejudi1_.ds_icone as ds14_291_1_, classejudi1_.in_ignora_compensacao as in15_291_1_, classejudi1_.in_ignora_prevencao as in16_291_1_, classejudi1_.in_incidental as in17_291_1_, classejudi1_.in_inicial as in18_291_1_, classejudi1_.in_jus_postulandi as in19_291_1_, classejudi1_.ds_mensagem as ds22_291_1_, classejudi1_.ds_natureza as ds23_291_1_, classejudi1_.ds_norma as ds24_291_1_, classejudi1_.in_exige_pauta as in25_291_1_, classejudi1_.nr_piso_valor_causa as nr26_291_1_, classejudi1_.id_polo_ativo as id38_291_1_, classejudi1_.id_polo_passivo as id39_291_1_, classejudi1_.in_possui_custa as in27_291_1_, classejudi1_.in_possui_filhos as in28_291_1_, classejudi1_.tp_processo_referencia as tp29_291_1_, classejudi1_.in_reclama_polo_passivo as in30_291_1_, classejudi1_.in_recursal as in31_291_1_, classejudi1_.in_exige_revisor as in32_291_1_, classejudi1_.in_segredo_justica as in33_291_1_, classejudi1_.nr_teto_valor_causa as nr34_291_1_, classejudi1_.id_tipo_audiencia as id40_291_1_, classejudi1_.vl_peso as vl35_291_1_, classejudi1_.id_classe_judicial_pai as id36_0__, classejudi1_.id_classe_judicial as id1_0__ from tb_classe_judicial classejudi0_ left outer join tb_classe_judicial classejudi1_ on classejudi0_.id_classe_judicial=classejudi1_.id_classe_judicial_pai where classejudi0_.id_classe_judicial_pai is null order by classejudi0_.ds_classe_judicial, classejudi1_.ds_classe_judicial, classejudi1_.ds_classe_judicial asc TopMemoryContext: 88840 total in 12 blocks; 4008 free (10 chunks); 84832 used Operator lookup cache: 24576 total in 2 blocks; 11888 free (5 chunks); 12688 used Prepared Queries: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used TopTransactionContext: 8192 total in 1 blocks; 7328 free (0 chunks); 864 used MessageContext: 24576 total in 2 blocks; 14192 free (5 chunks); 10384 used CFuncHash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used Operator class cache: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used smgr relation table: 24576 total in 2 blocks; 9808 free (4 chunks); 14768 used TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used Portal hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used PortalMemory: 8192 total in 1 blocks; 7888 free (0 chunks); 304 used PortalHeapMemory: 1024 total in 1 blocks; 944 free (0 chunks); 80 used Relcache by OID: 24576 total in 2 blocks; 13872 free (3 chunks); 10704 used CacheMemoryContext: 828112 total in 21 blocks; 17352 free (0 chunks); 810760 used pg_constraint_conrelid_index: 2048 total in 1 blocks; 728 free (0 chunks); 1320 used pg_attrdef_adrelid_adnum_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used pg_toast_2618_index: 2048 total in 1 blocks; 664 free (0 chunks); 1384 used vs_situacao_processo_new: 162816 total in 22 blocks; 2400 free (0 chunks); 160416 used unnamed prepared statement: 122880 total in 4 blocks; 24912 free (105 chunks); 97968 used CachedPlan: 1024 total in 1 blocks; 784 free (0 chunks); 240 used CachedPlanSource: 1024 total in 1 blocks; 504 free (1 chunks); 520 used pg_db_role_setting_databaseid_rol_index: 2048 total in 1 blocks; 712 free (0 chunks); 1336 used pg_opclass_am_name_nsp_index: 3072 total in 2 blocks; 1544 free (2 chunks); 1528 used pg_foreign_data_wrapper_name_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_enum_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_class_relname_nsp_index: 3072 total in 2 blocks; 1656 free (3 chunks); 1416 used pg_foreign_server_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_statistic_relid_att_inh_index: 3072 total in 2 blocks; 1544 free (2 chunks); 1528 used pg_cast_source_target_index: 3072 total in 2 blocks; 1656 free (3 chunks); 1416 used pg_language_name_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_collation_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_amop_fam_strat_index: 3072 total in 2 blocks; 1544 free (2 chunks); 1528 used pg_index_indexrelid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_ts_template_tmplname_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_ts_config_map_index: 3072 total in 2 blocks; 1544 free (2 chunks); 1528 used pg_opclass_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_foreign_data_wrapper_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_ts_dict_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_conversion_default_index: 3072 total in 2 blocks; 1496 free (2 chunks); 1576 used pg_operator_oprname_l_r_n_index: 3072 total in 2 blocks; 1496 free (2 chunks); 1576 used pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1656 free (3 chunks); 1416 used pg_enum_typid_label_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_ts_config_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_user_mapping_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_opfamily_am_name_nsp_index: 3072 total in 2 blocks; 1544 free (2 chunks); 1528 used pg_foreign_table_relid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_type_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_aggregate_fnoid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_constraint_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_rewrite_rel_rulename_index: 3072 total in 2 blocks; 1656 free (3 chunks); 1416 used pg_ts_parser_prsname_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_ts_config_cfgname_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_ts_parser_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_operator_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_namespace_nspname_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_ts_template_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_amop_opr_fam_index: 3072 total in 2 blocks; 1544 free (2 chunks); 1528 used pg_default_acl_role_nsp_obj_index: 3072 total in 2 blocks; 1544 free (2 chunks); 1528 used pg_collation_name_enc_nsp_index: 3072 total in 2 blocks; 1544 free (2 chunks); 1528 used pg_ts_dict_dictname_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_type_typname_nsp_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_opfamily_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_class_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_proc_proname_args_nsp_index: 3072 total in 2 blocks; 1544 free (2 chunks); 1528 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1656 free (3 chunks); 1416 used pg_proc_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_language_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_namespace_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1496 free (2 chunks); 1576 used pg_foreign_server_name_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_attribute_relid_attnam_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_conversion_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_user_mapping_user_server_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_conversion_name_nsp_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_authid_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_auth_members_member_role_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_tablespace_oid_index: 3072 total in 2 blocks; 1768 free (4 chunks); 1304 used pg_database_datname_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_auth_members_role_member_index: 3072 total in 2 blocks; 1704 free (4 chunks); 1368 used pg_database_oid_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_authid_rolname_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used MdSmgr: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used LOCALLOCK hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used Timezones: 83472 total in 2 blocks; 3744 free (0 chunks); 79728 used ErrorContext: 8192 total in 1 blocks; 8160 free (4 chunks); 32 used ERROR: out of memory at character 357 Luiz Carlos
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
