Thiago, os dados são: max_connections = 1800 shared_buffer= 32Mb
Abr, Guilherme -----Mensagem original----- De: [email protected] [mailto:[email protected]] Em nome de Thiago Avelino Enviada em: quarta-feira, 28 de janeiro de 2009 13:04 Para: Comunidade PostgreSQL Brasileira Assunto: Re: [pgbr-geral] Falta de memoria De uma olhada no seu postgresql.conf, lá tem 'shared_buffer', me reporta o que esta lá. 2009/1/28 Guilherme Vianna de Aguiar <[email protected]> > > Boa tarde, > > houve um erro no Postgres de uma das maquinas aqui da empresa. > > > > Depois de um tempo que a aplicação está rodando dá o erro de falta de memória. O banco não chega a cair. > > O log: > > > > 22:33:55.471 BRDTERROR: out of memory > > Operator class cache: 8192 total in 1 blocks; 3848 free (0 chunks); 4344 used > > PL/PgSQL function context: 8192 total in 1 blocks; 2472 free (9 chunks); 5720 used > > Rendezvous variable hash: 8192 total in 1 blocks; 3848 free (0 chunks); 4344 used > > PLpgSQL function cache: 24328 total in 2 blocks; 5904 free (0 chunks); 18424 used > > Record information cache: 8192 total in 1 blocks; 1800 free (0 chunks); 6392 used > > TopTransactionContext: 8192 total in 1 blocks; 7312 free (0 chunks); 880 used > > ExecutorState: 8192 total in 1 blocks; 6832 free (0 chunks); 1360 used > > ExprContext: 8192 total in 1 blocks; 8176 free (0 chunks); 16 used > > SPI Exec: 8192 total in 1 blocks; 7992 free (0 chunks); 200 used > > ExecutorState: 73856 total in 5 blocks; 26064 free (5 chunks); 47792 used > > TIDBitmap: 24576 total in 2 blocks; 2800 free (8 chunks); 21776 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: 8192 total in 1 blocks; 8160 free (0 chunks); 32 used > > AggContext: 8192 total in 1 blocks; 8104 free (0 chunks); 88 used > > TupleHashTable: 8192 total in 1 blocks; 5704 free (0 chunks); 2488 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 > > SPI Proc: 8192 total in 1 blocks; 6632 free (2 chunks); 1560 used > > MessageContext: 8192 total in 1 blocks; 7072 free (0 chunks); 1120 used > > CFuncHash: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used > > MbProcContext: 1024 total in 1 blocks; 928 free (7 chunks); 96 used > > smgr relation table: 8192 total in 1 blocks; 2808 free (0 chunks); 5384 used > > TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks); 16 used > > Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used > > PortalMemory: 8192 total in 1 blocks; 8040 free (0 chunks); 152 used > > PortalHeapMemory: 15360 total in 4 blocks; 3400 free (0 chunks); 11960 used > > ExecutorState: 8192 total in 1 blocks; 712 free (6 chunks); 7480 used > > ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used > > Relcache by OID: 8192 total in 1 blocks; 3376 free (0 chunks); 4816 used > > CacheMemoryContext: 667472 total in 20 blocks; 202696 free (0 chunks); 464776 used > > CachedPlan: 15360 total in 4 blocks; 2856 free (0 chunks); 12504 used > > CachedPlanSource: 3072 total in 2 blocks; 624 free (0 chunks); 2448 used > > SPI Plan: 1024 total in 1 blocks; 904 free (0 chunks); 120 used > > idx_UNIQ_mo_queue: 1024 total in 1 blocks; 72 free (0 chunks); 952 used > > mo_queue_idx_lote: 1024 total in 1 blocks; 344 free (0 chunks); 680 used > > idx_mo_queue=processed: 1024 total in 1 blocks; 304 free (0 chunks); 720 used > > idx_mo_queue=importer_host: 1024 total in 1 blocks; 344 free (0 chunks); 680 used > > mo_queue_pkey: 1024 total in 1 blocks; 344 free (0 chunks); 680 used > > pg_index_indrelid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used > > pg_attrdef_adrelid_adnum_index: 1024 total in 1 blocks; 240 free (0 chunks); 784 used > > CachedPlan: 1024 total in 1 blocks; 528 free (0 chunks); 496 used > > CachedPlanSource: 3072 total in 2 blocks; 2000 free (3 chunks); 1072 used > > SPI Plan: 1024 total in 1 blocks; 928 free (0 chunks); 96 used > > unnamed prepared statement: 24576 total in 2 blocks; 3576 free (6 chunks); 21000 used > > pg_ts_dict_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used > > pg_aggregate_fnoid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used > > pg_language_name_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used > > pg_statistic_relid_att_index: 1024 total in 1 blocks; 240 free (0 chunks); 784 used > > pg_ts_dict_dictname_index: 1024 total in 1 blocks; 280 free (0 chunks); 744 used > > pg_namespace_nspname_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used > > pg_opfamily_oid_index: 1024 total in 1 blocks; 344 free (0 chunks); 680 used > > pg_opclass_oid_index: 1024 total in 1 blocks; 304 free (0 chunks); 720 used > > pg_ts_parser_prsname_index: 1024 total in 1 blocks; 280 free (0 chunks); 744 used > > pg_amop_fam_strat_index: 1024 total in 1 blocks; 88 free (0 chunks); 936 used > > > > LOCALLOCK hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used > > Timezones: 48616 total in 2 blocks; 5968 free (0 chunks); 42648 used > > ErrorContext: 8192 total in 1 blocks; 8176 free (4 chunks); 16 used > > > > Obrigado, > > Guilherme Vianna > > > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > -- att. _ °v° Thiago Avelino /(_)\ Programador | SysAdmin ^ ^ Celular: (11) 7660-2933 www.avelino.us | www.centos-br.org _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.233 / Virus Database: 270.10.15/1921 - Release Date: 01/28/09 06:37:00 _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
