Postgres Pro
Downloads
Home   >   mailing lists

Re: Better use of memory - Mailing list pgsql-novice

From Jayadevan
Subject Re: Better use of memory
Date
Msg-id 1406952189896-5813590.post@n5.nabble.com
Whole thread Raw
In response to Re: Better use of memory  ("Jake O'brien Fagan" <jake@househappy.org>)
List pgsql-novice
Tree view 
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.

pgsql-novice by date:

Previous
From: "Jake O'brien Fagan"
Date:
Subject: Re: Better use of memory
Next
From: "Marc Richter"
Date:
Subject: Grabing and applying a dump