> # - 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)
Bem.... tente aumentar a maintenance_work_mem ... Quanto de memória possui o servidor ?? -- Att: Thiago Risso _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
