[PERFORM] Very slow query in PostgreSQL 9.3.3

2014-03-13 Thread fburgess
PostgreSQL 9.3.3 RHEL 6.4Total db Server memory 64GB# -# PostgreSQL configuration file# -max_connections = 100shared_buffers = 16GBwork_mem = 32MB maintenance_work_mem = 1GBseq_page_cost = 1.0 random_page_cost = 2.0 cpu_tuple_cost = 0.03

Re: [PERFORM] [BUGS] Very slow query in PostgreSQL 9.3.3

2014-03-13 Thread Pavel Stehule
2014-03-13 20:26 GMT+01:00 fburg...@radiantblue.com: PostgreSQL 9.3.3 RHEL 6.4 Total db Server memory 64GB # - # PostgreSQL configuration file # - max_connections = 100 shared_buffers = 16GB work_mem = 32MB maintenance_work_mem =

Re: [PERFORM] [BUGS] Very slow query in PostgreSQL 9.3.3

2014-03-13 Thread Sergey Konoplev
On Thu, Mar 13, 2014 at 12:26 PM, fburg...@radiantblue.com wrote: *** Problem Query *** explain (analyze on, buffers on) Select * from measurement this_ where this_.logdate between '2007-12-19 23:38:41.22'::timestamp and '2007-12-20 08:01:04.22'::timestamp

Re: [PERFORM] Very slow query in PostgreSQL 9.3.3

2014-03-13 Thread Ian Lawrence Barwick
2014-03-14 4:26 GMT+09:00 fburg...@radiantblue.com: PostgreSQL 9.3.3 RHEL 6.4 Total db Server memory 64GB (...) effective_cache_size = 48MB I'm not sure if this will help directly, but is the value for 'effective_cache_size' intentional? 48 *GB* would be a more likely setting. Regards Ian