Hi, On Monday, November 28, 2011 08:55:28 PM Gurjeet Singh wrote: > This may not be necessary, but can you please share the modified config you > used for the last run. I just copied the .conf I had for some independent development.
max_connections = 100 listen_addresses = '' port=5432 shared_buffers = 2GB temp_buffers = 64MB work_mem = 96MB maintenance_work_mem = 1GB effective_cache_size = 20GB log_line_prefix = '%d %a %c %v %x %m ' # special values: log_statement = 'ddl' #decreases variance track_activities = off track_counts = off autovacuum = off update_process_title = off logging_collector = off log_destination = stderr log_min_messages = error log_checkpoints = on log_autovacuum_min_duration=0 synchronous_commit = off checkpoint_segments = 30 checkpoint_timeout = 30min checkpoint_completion_target = 0.8 log_error_verbosity = verbose But about the only thing really important is the shared_buffers difference (commenting it out nearly yielded the former speed) Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
