2014-03-14 4:26 GMT+09:00 :
> 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 Barwick
--
Sent v
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
>
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
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_p