Обсуждение: cache Memory

Поиск
Список
Период
Сортировка

cache Memory

От
"AL-Temimi, Muthana"
Дата:

Hello,

 

we have postgresql 9.1 installed on Suse Enterprice Linux Server. The RAM is 12GB, When the concurrent connections 275 reached the cached memory  on Server 5GB and when the concurrent increased into 305 increase also the cache memory 8.5GB. but when the concurrent connections decreased into for example 165 the cache memory not decreased. The question why? Did I mess something the postgresql.conf

 

any help will be grateful..

 

Best Regards

 

Muthana AL-Temimi

M.Sc. Informations- und Kommunikations-Systeme

 

Technische Universitaet Hamburg Harburg

-Rechenzentrum-

Am Schwarzenberg-Campus 3

D-21073 Hamburg

 

Tel.:  +49.40.42878.2338

Fax.: +49.40.42793.5160

E-Mail: m.al@tu-harburg.de

http://www.tu-harburg.de/rzt

 

 

Re: cache Memory

От
Scott Ribe
Дата:
On Jun 8, 2015, at 7:23 AM, AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de> wrote:
>
> we have postgresql 9.1 installed on Suse Enterprice Linux Server. The RAM is 12GB, When the concurrent connections
275reached the cached memory  on Server 5GB and when the concurrent increased into 305 increase also the cache memory
8.5GB.but when the concurrent connections decreased into for example 165 the cache memory not decreased. The question
why?Did I mess something the postgresql.conf 

- What are your memory-related config settings?

- Consider using pgbouncer to reduce the number of connections.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







Re: cache Memory

От
Scott Ribe
Дата:
On Jun 8, 2015, at 7:23 AM, AL-Temimi, Muthana <muthana.al-temimi@tu-harburg.hamburg.de> wrote:
>
> we have postgresql 9.1 installed on Suse Enterprice Linux Server. The RAM is 12GB, When the concurrent connections
275reached the cached memory  on Server 5GB and when the concurrent increased into 305 increase also the cache memory
8.5GB.but when the concurrent connections decreased into for example 165 the cache memory not decreased. The question
why?Did I mess something the postgresql.conf 
>
> any help will be grateful..

Probably also good to confirm what you mean by "cache memory"--what exactly are you measuring? For instance, if you're
measuringthe OS cache for the file system, then no, it wouldn't be expected to ever decrease until something else
neededthe memory... 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice