Obrigado pelo interesse. Segue abaixo: Já havia pensado em atualizar a versão do banco, mas essa versào recomendada tem melhorias segnificativas para justificar uma migração, sei que a 8.3 muita coisa mudou...
Parametros o Ipcs... Quanto aos parâmetros do postgresql.conf, retifico -os: Quanto aos demais parâmetros não mencionados, com exceçào dos parametros de logs estão conforme padrão da instalação. max_connections = 90 max_prepard_transaction = 5 superuser_reserved_connections = 3 //acrescentado shared_buffers = 1024MB work_mem = 128MB maintenance_work_mem = 256MB //ratificado 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 = 128KB 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 autovacuum_freeze_max_age = 200000000 //acrescentado deadlock_timeout = 1s max_locks_per_transaction = 64 stats_command_string = on //acrescentado update_process_title = on //acrescentado stats_start_collector = on //acrescentado stats_block_level = off //acrescentado stats_row_level = on //acrescentado ipcs -u ------ Shared Memory Status -------- segments allocated 1 pages allocated 269174 pages resident 268001 pages swapped 0 Swap performance: 0 attempts 0 successes ------ Semaphore Status -------- used arrays = 6 allocated semaphores = 102 ------ Messages: Status -------- allocated queues = 0 used headers = 0 used space = 0 bytes ipcs -l ------ Shared Memory Limits -------- max number of segments = 1 max seg size (kbytes) = 2097152 max total shared memory (pages) = 2147483648 min seg size (bytes) = 1 ------ Semaphore Limits -------- max number of arrays = 128 max semaphores per array = 250 max semaphores system wide = 32000 max ops per semop call = 100 semaphore max value = 32767 ------ Messages: Limits -------- max queues system wide = 16 max size of message (bytes) = 65536 default max size of queue (bytes) = 65536
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
