Segue as configuracoes de memoria: # - Memory -
shared_buffers = 32MB # min 128kB or max_connections*16kB #temp_buffers = 8MB # min 800kB #max_prepared_transactions = 5 # can be 0 or more # Note: increasing max_prepared_transactions costs ~600 bytes of shared memory # per transaction slot, plus lock space (see max_locks_per_transaction). #work_mem = 1MB # min 64kB #maintenance_work_mem = 16MB # min 1MB #max_stack_depth = 2MB # min 100kB # - Free Space Map - max_fsm_pages = 204800 # min max_fsm_relations*16, 6 bytes each #max_fsm_relations = 1000 # min 100, ~70 bytes each # - Kernel Resource Usage - #max_files_per_process = 1000 # min 25 #shared_preload_libraries = '' # (change requires restart) Thiago Risso escreveu: >> pg_locks L INNER JOIN pg_class C ON C.oid = L.relation; >> >> >> locktype | mode | relname >> ----------+-----------------+---------------------------- >> relation | AccessShareLock | pg_locks >> relation | AccessShareLock | pg_class_oid_index >> relation | AccessShareLock | pg_class_relname_nsp_index >> relation | AccessShareLock | pg_class >> (4 rows) >> > > Não tem nenhum LOCK... ! > Pelo e-mail anterior parece ser problema de alocação de memória.. > Qual as configuração do postgresql.conf (As de diretivas de memória). > > > _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
