Postgres Pro
Downloads
Home   >   mailing lists

Re: Very slow query in PostgreSQL 9.3.3 - Mailing list pgsql-performance

From Ian Lawrence Barwick
Subject Re: Very slow query in PostgreSQL 9.3.3
Date
Msg-id CAB8KJ=j3Yvvq4J-LPJYOoFqya+G=R07yNgv3NMDH+o_PMOnr0g@mail.gmail.com
Whole thread Raw
In response to Very slow query in PostgreSQL 9.3.3  (<fburgess@radiantblue.com>)
List pgsql-performance
Tree view 
2014-03-14 4:26 GMT+09:00  <fburgess@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 Barwick

pgsql-performance by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: [BUGS] Very slow query in PostgreSQL 9.3.3
Next
From: "acanada"
Date:
Subject: Adding new field to big table