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?  (Tom Lane <tgl@sss.pgh.pa.us>)
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:

Previous
From: Kenichiro Tanaka
Date:
Subject: Re: Can't start server
Next
From: Tom Lane
Date:
Subject: Re: TopMemoryContext - Configuration Mistake?