From: | vamsi krishna <vamsikrishna1902(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Total memory allocated to postgres |
Date: | 2010-10-08 14:37:52 |
Message-ID: | AANLkTimm+H+Swn_NOQywGAcXkEYjG2oU9sFgzSat_TYf@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi
I want to know how much main memory is actually allocated to be the maximum
memory for postgresql, because my hardware may have 4GB main memory but at
the end of the day, only 1GB may be allocated for postgres.
I want to set (increase) it manually. Can someone tell me how to do it?
In aset.c we have a function
AllocSetContextCreate(MemoryContext parent,const char *name,Size
minContextSize,Size initBlockSize,Size maxBlockSize) defn.
maxBlockSize is initialized to 8MB in mcxt.c where AllocSetContextCreate()
is called. If I increase this value to 80 MB or so, will it increase the
memory allocated to postgresql or will it just increase the block size?
OR
do I need to change some parameter in postgresql.conf file in data directory
in pgsql folder?
Thanks
Vamsi
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-10-08 14:38:15 | Re: Issues with Quorum Commit |
Previous Message | Markus Wanner | 2010-10-08 14:37:12 | Re: Issues with Quorum Commit |