TopMemoryContext - Configuration Mistake? - Mailing list pgsql-admin
From | Edoardo Innocenti |
---|---|
Subject | TopMemoryContext - Configuration Mistake? |
Date | |
Msg-id | 4C6932DF.90102@savinodelbene.com Whole thread Raw |
Responses |
Re: TopMemoryContext - Configuration Mistake?
|
List | pgsql-admin |
I got the following error during a select query.<br /><br /> May it be a config error, or is it a bug?<br /><br /> TopMemoryContext:186872 total in 15 blocks; 16544 free (41 chunks); 170328 used<br /> TopTransactionContext: 8192 totalin 1 blocks; 7568 free (0 chunks); 624 used<br /> Type information cache: 24576 total in 2 blocks; 11888 free (5 chunks);12688 used<br /> Operator class cache: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used<br /> Operatorlookup cache: 24576 total in 2 blocks; 11888 free (5 chunks); 12688 used<br /> MessageContext: 2042626048 totalin 256 blocks; 16072 free (7 chunks); 2042609976 used<br /> JoinRelHashTable: 1040384 total in 7 blocks; 512384free (12 chunks); 528000 used<br /> smgr relation table: 24576 total in 2 blocks; 9776 free (4 chunks); 14800 used<br/> TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used<br /> Portal hash: 8192 totalin 1 blocks; 1680 free (0 chunks); 6512 used<br /> PortalMemory: 8192 total in 1 blocks; 8160 free (1 chunks); 32used<br /> Relcache by OID: 24576 total in 2 blocks; 12832 free (3 chunks); 11744 used<br /> CacheMemoryContext: 2549344total in 23 blocks; 986984 free (1 chunks); 1562360 used<br /> gen_porti_sched_pkey: 2048 total in 1 blocks; 656free (0 chunks); 1392 used<br /> m_zondes_pkey: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used<br /> oevi_1:2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> oe_vessel_imbarco_pkey: 2048 total in 1 blocks; 632free (0 chunks); 1416 used<br /> m_zonmar_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> m_tipmer_pkey:2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> m_cianav_pkey: 2048 total in 1 blocks; 656free (0 chunks); 1392 used<br /> oev_1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> oe_vessel_t_pkey:2048 total in 1 blocks; 656 free (0 chunks); 1392 used<br /> mmerca_cod_emb: 2048 total in 1 blocks;752 free (0 chunks); 1296 used<br /> m_merca_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> m_aeropu_pkey: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used<br /> mcli_nome: 2048 total in 1 blocks;752 free (0 chunks); 1296 used<br /> mcli_acro: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> <m_cli_x1>: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> m_cli_pkey: 2048 total in 1 blocks;752 free (0 chunks); 1296 used<br /> oec_2: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> oec_1:2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> oe_container_booking_nr_progr_ctnr_azienda_key: 2048total in 1 blocks; 632 free (0 chunks); 1416 used<br /> oe_container_pkey: 2048 total in 1 blocks; 632 free (0 chunks);1416 used<br /> oem_x1: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> oe_sped_m_pkey: 2048total in 1 blocks; 632 free (0 chunks); 1416 used<br /> ref_sales_pkey: 2048 total in 1 blocks; 440 free (0 chunks);1608 used<br /> oes_x7: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> oes_x6: 2048 total in1 blocks; 752 free (0 chunks); 1296 used<br /> oes_x5: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> oes_x4: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> oes_x3: 2048 total in 1 blocks; 752 free (0chunks); 1296 used<br /> oes_x2: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> oes_x1: 2048 totalin 1 blocks; 752 free (0 chunks); 1296 used<br /> oe_sped_t_pkey: 2048 total in 1 blocks; 656 free (0 chunks); 1392used<br /> navig_save_pkey: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used<br /> navig_fields_pkey: 2048total in 1 blocks; 632 free (0 chunks); 1416 used<br /> navig_subarea_pkey: 2048 total in 1 blocks; 656 free (0 chunks);1392 used<br /> navig_area_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> navig_left_table_pkey:2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> gnp_cod_tipo_par: 2048 total in 1blocks; 608 free (0 chunks); 1440 used<br /> gen_param_pkey: 2048 total in 1 blocks; 632 free (0 chunks); 1416 used<br/> glchart_groups_pk_gr: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> pg_attrdef_oid_index:2048 total in 1 blocks; 752 free (0 chunks); 1296 used<br /> empresa_pkey: 2048 total in 1 blocks;704 free (0 chunks); 1344 used<br /> pg_attrdef_adrelid_adnum_index: 2048 total in 1 blocks; 608 free (0 chunks);1440 used<br /> pg_index_indrelid_index: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used<br /> pg_ts_dict_oid_index:3072 total in 2 blocks; 1744 free (3 chunks); 1328 used<br /> pg_aggregate_fnoid_index: 3072 totalin 2 blocks; 1696 free (2 chunks); 1376 used<br /> pg_language_name_index: 3072 total in 2 blocks; 1744 free (3chunks); 1328 used<br /> pg_statistic_relid_att_index: 3072 total in 2 blocks; 1600 free (2 chunks); 1472 used<br /> pg_ts_dict_dictname_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used<br /> pg_namespace_nspname_index:3072 total in 2 blocks; 1696 free (2 chunks); 1376 used<br /> pg_opfamily_oid_index: 3072total in 2 blocks; 1744 free (3 chunks); 1328 used<br /> pg_opclass_oid_index: 3072 total in 2 blocks; 1696 free(2 chunks); 1376 used<br /> pg_ts_parser_prsname_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used<br/> pg_amop_fam_strat_index: 3072 total in 2 blocks; 1384 free (2 chunks); 1688 used<br /> pg_opclass_am_name_nsp_index:3072 total in 2 blocks; 1576 free (3 chunks); 1496 used<br /> pg_trigger_tgrelid_tgname_index:3072 total in 2 blocks; 1600 free (2 chunks); 1472 used<br /> pg_cast_source_target_index:3072 total in 2 blocks; 1600 free (2 chunks); 1472 used<br /> pg_auth_members_role_member_index:3072 total in 2 blocks; 1648 free (2 chunks); 1424 used<br /> pg_attribute_relid_attnum_index:3072 total in 2 blocks; 1600 free (2 chunks); 1472 used<br /> pg_ts_config_cfgname_index:3072 total in 2 blocks; 1648 free (2 chunks); 1424 used<br /> pg_authid_oid_index: 3072 totalin 2 blocks; 1696 free (2 chunks); 1376 used<br /> pg_ts_config_oid_index: 3072 total in 2 blocks; 1744 free (3chunks); 1328 used<br /> pg_conversion_default_index: 3072 total in 2 blocks; 1432 free (3 chunks); 1640 used<br /> pg_language_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used<br /> pg_enum_oid_index: 3072 totalin 2 blocks; 1744 free (3 chunks); 1328 used<br /> pg_proc_proname_args_nsp_index: 3072 total in 2 blocks; 1576free (3 chunks); 1496 used<br /> pg_ts_parser_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used<br/> pg_database_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used<br /> pg_conversion_name_nsp_index:3072 total in 2 blocks; 1648 free (2 chunks); 1424 used<br /> pg_class_relname_nsp_index:3072 total in 2 blocks; 1600 free (2 chunks); 1472 used<br /> pg_attribute_relid_attnam_index:3072 total in 2 blocks; 1648 free (2 chunks); 1424 used<br /> pg_class_oid_index: 3072total in 2 blocks; 1696 free (2 chunks); 1376 used<br /> pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1384 free(2 chunks); 1688 used<br /> pg_operator_oprname_l_r_n_index: 3072 total in 2 blocks; 1384 free (2 chunks); 1688 used<br/> pg_index_indexrelid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used<br /> pg_type_oid_index:3072 total in 2 blocks; 1696 free (2 chunks); 1376 used<br /> pg_rewrite_rel_rulename_index: 3072 totalin 2 blocks; 1648 free (2 chunks); 1424 used<br /> pg_authid_rolname_index: 3072 total in 2 blocks; 1696 free (2chunks); 1376 used<br /> pg_auth_members_member_role_index: 3072 total in 2 blocks; 1600 free (2 chunks); 1472 used<br/> pg_enum_typid_label_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used<br /> pg_constraint_oid_index:3072 total in 2 blocks; 1744 free (3 chunks); 1328 used<br /> pg_conversion_oid_index: 3072 totalin 2 blocks; 1744 free (3 chunks); 1328 used<br /> pg_ts_template_tmplname_index: 3072 total in 2 blocks; 1648 free(2 chunks); 1424 used<br /> pg_ts_config_map_index: 3072 total in 2 blocks; 1624 free (3 chunks); 1448 used<br /> pg_namespace_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used<br /> pg_type_typname_nsp_index:3072 total in 2 blocks; 1600 free (2 chunks); 1472 used<br /> pg_operator_oid_index: 3072 totalin 2 blocks; 1696 free (2 chunks); 1376 used<br /> pg_amop_opr_fam_index: 3072 total in 2 blocks; 1600 free (2 chunks);1472 used<br /> pg_proc_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used<br /> pg_opfamily_am_name_nsp_index:3072 total in 2 blocks; 1624 free (3 chunks); 1448 used<br /> pg_ts_template_oid_index:3072 total in 2 blocks; 1744 free (3 chunks); 1328 used<br /> MdSmgr: 8192 total in 1 blocks;5664 free (0 chunks); 2528 used<br /> LOCALLOCK hash: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used<br/> Timezones: 53584 total in 2 blocks; 3744 free (0 chunks); 49840 used<br /> ErrorContext: 24576 total in 3 blocks;24480 free (18 chunks); 96 used<br /> 2010-08-03 10:48:03 CEST [31005]: [658-1] ERROR: out of memory<br /><br /><divclass="moz-signature">-- <br /></div><pre class="moz-signature" cols="72"><font face="Verdana"><b><font color="#000000">EdoardoInnocenti </font></b><small><font color="#000000">Infrastructure Coordinator</font></small> <font color="#000000"> <b>SDB Information Technology</b> <small>Phone: +39.055.3811222 Fax: +39.055.5201411</small></font></font></pre><br /><div style="text-align: center; width: 620px; font-family: Verdana;"><small>Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili,anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e aglialtri Suoi diritti, sono riportate alla pagina <a href="http://www.savinodelbene.com/news/privacy.html">http://www.savinodelbene.com/news/privacy.html</a><br/> Se avete ricevutoquesto messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati,ai sensi art. 616 codice penale <a href="http://www.savinodelbene.com/codice_penale_616.html">http://www.savinodelbene.com/codice_penale_616.html</a><br/> L'Aziendanon si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei all'attivitàlavorativa o contrari a norme. </small></div><br />
pgsql-admin by date: