Pessoal, Por favor, gostaria de auxilio/informações acerca de um problema ocorrido recentemente e que só se normalizou com o re-start do servidor, pois os erros apresentados dificulta identificar a causa. Para melhor entendimento/clareza, estou informando informações do servidor, configurações do postgresql.conf e ao final as ocorrências geradas no log, que ao final apresenta mensagem de sem memória e falha ao requisitar o tamanho 32.
Equipamento Dedicado ao banco DELL PowerEdge 1800 - 8GB - HD SCSI - OpenSuse 10.2 - PostGreSQL 8.2.4 - Dedicado ao Banco Postgresql.Conf max_connections = 90 max_prepard_transaction = 5 shared_buffers = 1024MB work_mem = 128MB maintenance_work_me = 256 max_stack_depth = 4MB max_fsm_pages = 204800 max_fsm_relations = 1000 vacuum_cost_delay = 100 fsync = on wal_sync_method = fsync full_page_writes = on wal_buffers = 128k commit_dalay = 500 commit_siblings = 5 checkpoint_segments = 16 checkpoint_timeout = 5min checkpoint_warning = 30s enable_bitmapscan = on enable_hashagg = on enable_hashjoin = on enable_indexscan = on enable_mergejoin = on enable_nestloop = on enable_seqscan = on enable_sort = on enable_tidscan = on random_page_cost = 3.0 effective_cache_size = 4GB autovacuum = on autovacuum_naptime = 3min autovacuum_threshold = 500 deadlock_timeout = 1s max_locks_per_transaction = 64 Log ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used AggContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used AggContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used AggContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used Unique: 0 total in 0 blocks; 0 free (0 chunks); 0 used Relcache by OID: 24576 total in 2 blocks; 14912 free (3 chunks); 9664 used CacheMemoryContext: 820440 total in 21 blocks; 43368 free (0 chunks); 777072 used notafiscal_ordemfaturamento_id_idx: 2048 total in 1 blocks; 728 free (0 chunks); 1320 used notafiscal_numero_notafiscal_unique: 2048 total in 1 blocks; 824 free (0 chunks); 1224 used notafiscal_numero_notafiscal_principal_idx: 2048 total in 1 blocks; 824 free (0 chunks); 1224 used notafiscal_natureza_oper_id_idx: 2048 total in 1 blocks; 824 free (0 chunks); 1224 used notafiscal_nat_oper_gera_credito_idx: 2048 total in 1 blocks; 824 free (0 chunks); 1224 used notafiscal_impressa_idx: 2048 total in 1 blocks; 824 free (0 chunks); 1224 used notafiscal_data_emissao_idx: 2048 total in 1 blocks; 128 free (0 chunks); 1920 used notafiscal_cliente_id_idx: 2048 total in 1 blocks; 512 free (0 chunks); 1536 used notafiscal_cancelada_idx: 2048 total in 1 blocks; 528 free (0 chunks); 1520 used notafiscal_pkey: 2048 total in 1 blocks; 824 free (0 chunks); 1224 used notafiscal_int_ordemfaturamento_id_idx: 2048 total in 1 blocks; 728 free (0 chunks); 1320 used notafiscal_int_numero_notafiscal_unique: 2048 total in 1 blocks; 824 free (0 chunks); 1224 used notafiscal_int_numero_notafiscal_principal_idx: 2048 total in 1 blocks; 824 free (0 chunks); 1224 used pg_opclass_oid_index: 3072 total in 2 blocks; 1816 free (3 chunks); 1256 used pg_opclass_am_name_nsp_index: 3072 total in 2 blocks; 1664 free (3 chunks); 1408 used pg_namespace_oid_index: 3072 total in 2 blocks; 1768 free (3 chunks); 1304 used pg_namespace_nspname_index: 3072 total in 2 blocks; 1768 free (3 chunks); 1304 used pg_language_oid_index: 3072 total in 2 blocks; 1816 free (3 chunks); 1256 used pg_language_name_index: 3072 total in 2 blocks; 1816 free (3 chunks); 1256 used pg_inherits_relid_seqno_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_index_indexrelid_index: 3072 total in 2 blocks; 1768 free (3 chunks); 1304 used pg_authid_oid_index: 3072 total in 2 blocks; 1768 free (3 chunks); 1304 used pg_authid_rolname_index: 3072 total in 2 blocks; 1768 free (3 chunks); 1304 used pg_database_oid_index: 3072 total in 2 blocks; 1768 free (3 chunks); 1304 used pg_conversion_oid_index: 3072 total in 2 blocks; 1816 free (3 chunks); 1256 used pg_conversion_name_nsp_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_conversion_default_index: 3072 total in 2 blocks; 1520 free (1 chunks); 1552 used pg_class_relname_nsp_index: 3072 total in 2 blocks; 1672 free (3 chunks); 1400 used pg_class_oid_index: 3072 total in 2 blocks; 1768 free (3 chunks); 1304 used pg_cast_source_target_index: 3072 total in 2 blocks; 1672 free (3 chunks); 1400 used pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1672 free (3 chunks); 1400 used pg_attribute_relid_attnam_index: 3072 total in 2 blocks; 1720 free (3 chunks); 1352 used pg_amproc_opc_proc_index: 3072 total in 2 blocks; 1664 free (3 chunks); 1408 used pg_amop_opr_opc_index: 3072 total in 2 blocks; 1672 free (3 chunks); 1400 used pg_amop_opc_strat_index: 3072 total in 2 blocks; 1664 free (3 chunks); 1408 used pg_aggregate_fnoid_index: 3072 total in 2 blocks; 1768 free (3 chunks); 1304 used MdSmgr: 8192 total in 1 blocks; 7456 free (0 chunks); 736 used LOCALLOCK hash: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used Timezones: 53584 total in 2 blocks; 3744 free (0 chunks); 49840 used ErrorContext: 40960 total in 3 blocks; 40864 free (17 chunks); 96 used 2008-07-18 17:05:23 BRT montecarlo opencompany ERRO: sem memória 2008-07-18 17:05:23 BRT montecarlo opencompany DETALHE: Falhou ao requisitar o tamanho 32.
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
