Re: [PERFORM] Simple join doesn't use index

2013-02-04 Thread Dan Fairs
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

Re: [PERFORM] Unexpected sequence scan

2012-05-04 Thread Dan Fairs
efore changing production, but it looks good - thanks very much! Cheers, Dan -- Dan Fairs | dan.fa...@gmail.com | www.fezconsulting.com

[PERFORM] Unexpected sequence scan

2012-05-04 Thread Dan Fairs
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