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

2014-03-13 Thread Sergey Konoplev
On Thu, Mar 13, 2014 at 12:26 PM, 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: [GENERAL] [BUGS] Very slow query in PostgreSQL 9.3.3

2014-03-13 Thread Pavel Stehule
2014-03-13 20:26 GMT+01:00 : > 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 = 1GB > seq_pa