Apologies for leaping in a little late, but I note the version on Github has
been updated much more recently:
https://github.com/gregs1104/pgtune
Cheers,
Dan
--
Dan Fairs | dan.fa...@gmail.com | @danfairs | secondsync.com
efore changing production, but it looks good - thanks
very much!
Cheers,
Dan
--
Dan Fairs | dan.fa...@gmail.com | www.fezconsulting.com
ime=72.164..78.575 rows=1071 loops=1)
Filter: ((tx <= '2012-04-06 23:59:59+00'::timestamp with time
zone) AND (tx >= '2012-04-06 00:00:00+00'::timestamp with time zone))
-> Index Scan using twitter_tweet_transmission_id on twitter_tweet
(cost=0.00..5816.73 rows=4125 width=12) (actual time=0.003..0.277 rows=393
loops=1071)
Index Cond: (timecode_transmission.id =
twitter_tweet.transmission_id)
Total runtime: 470.421 ms
Non-default configuration (dev, PG9.1):
default_statistics_target = 100 # pgtune wizard 2012-01-11
maintenance_work_mem = 400MB # pgtune wizard 2012-01-11
constraint_exclusion = partition # pgtune wizard 2012-01-11
checkpoint_completion_target = 0.9 # pgtune wizard 2012-01-11
effective_cache_size = 7552MB # pgtune wizard 2012-01-11
work_mem = 50MB # pgtune wizard 2012-01-11
wal_buffers = 16MB # pgtune wizard 2012-01-11
checkpoint_segments = 16 # pgtune wizard 2012-01-11
shared_buffers = 3840MB # pgtune wizard 2012-01-11
max_connections = 80 # pgtune wizard 2012-01-11
Non-default configuration (prod, PG8.4)
maintenance_work_mem = 960MB
checkpoint_completion_target = 0.9
checkpoint_segments = 32
wal_buffers = 16MB
effective_cache_size = 11GB
shared_buffers = 4GB
max_connections = 32
work_mem = 100MB
--
Dan Fairs | dan.fa...@gmail.com | www.fezconsulting.com