| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com> |
| Subject: | Re: Avoiding repeated snapshot computation |
| Date: | 2011-11-29 22:00:50 |
| Message-ID: | 201111292300.51042.andres@anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2011-11-29 22:07:59 | Re: Patch - Debug builds without optimization |
| Previous Message | Kevin Grittner | 2011-11-29 21:54:49 | Re: autovacuum and default_transaction_isolation |