| From: | Jayadevan <maymala(dot)jayadevan(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Better use of memory |
| Date: | 2014-08-02 04:03:09 |
| Message-ID: | 1406952189896-5813590.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Richter | 2014-08-05 14:55:38 | Grabing and applying a dump |
| Previous Message | Jake O'brien Fagan | 2014-08-01 16:04:45 | Re: Better use of memory |