Re: Better use of memory

May be your active data set easily fits in the 1-2 GB range?  This will tell
you what is there in memory -
http://www.postgresql.org/docs/9.3/static/pgbuffercache.html
<http://www.postgresql.org/docs/9.3/static/pgbuffercache.html>
I am sure you have done this, still...the settings have taken effect? Are
you looking at the parameters in the  file or you also tried show command -
show shared_buffers;
 shared_buffers
----------------
 512MB
(1 row)




--
View this message in context: http://postgresql.1045698.n5.nabble.com/Better-use-of-memory-tp5813477p5813590.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.