Re: Why shared_buffers max is 8GB?

От: Markella Skempri
Тема: Re: Why shared_buffers max is 8GB?
Дата: ,
Msg-id: DUB128-DS145DB9710070BCB7857BE3E8640@phx.gbl
(см: обсуждение, исходный текст)
Ответ на: Re: Why shared_buffers max is 8GB?  (Martin French)
Ответы: Re: Why shared_buffers max is 8GB?  (Martin French)
Список: pgsql-performance

Скрыть дерево обсуждения

Why shared_buffers max is 8GB?  (Alexey Vasiliev, )
 Re: Why shared_buffers max is 8GB?  (Ilya Kosmodemiansky, )
  Re: Why shared_buffers max is 8GB?  (desmodemone, )
   Re: Why shared_buffers max is 8GB?  (Albe Laurenz, )
    Re: Why shared_buffers max is 8GB?  (desmodemone, )
   Re: Why shared_buffers max is 8GB?  (Markella Skempri, )
    Re: Why shared_buffers max is 8GB?  (Martin French, )
     Re: Why shared_buffers max is 8GB?  (Markella Skempri, )
      Re: Why shared_buffers max is 8GB?  (Martin French, )
    Re: Why shared_buffers max is 8GB?  (Scott Marlowe, )
     Re: Why shared_buffers max is 8GB?  (Shaun Thomas, )
      Re: Why shared_buffers max is 8GB?  (Ilya Kosmodemiansky, )
   Re: Why shared_buffers max is 8GB?  (Martin French, )
 Re: Why shared_buffers max is 8GB?  (Alexey Klyukin, )
  Re: Why shared_buffers max is 8GB?  (Bruce Momjian, )

 
Thanks Martin,
However this is a database dedicated server and nothing much else is running on it. Also, I never saw this happening with 9.2 – but I can’t vouch for the size of  files that I was uploading.
 
Sent: Wednesday, March 26, 2014 1:32 PM
Subject: Re: [PERFORM] Why shared_buffers max is 8GB?
 

> I wanted to follow up from this question. I’m running on 9.3.4

> My DB server has 32GB ram so I have assigned 8GB
> shared_buffer_memory. It is quite a big db but with not much
> traffic. When there is traffic, it’s usually big.


> Lately, the kernel has been killing the postmaster for having
> assigned too much shared memory. Latest crash was when loading a 500MB file.


> Should I reduce the shared buffers in order for this to be more robust?

> Thanks
> Markella

It may be that other memory settings are contributing towards this (work_mem, maintenance_work_mem, max_connections etc).

I would suggest that the OOM killer is working as intended and something is not quite right within the config.

You may want to review the memory consumption at peak times taking into consideration anything else running on the machine.
=============================================

Romax Technology Limited
A limited company registered in England and Wales.
Registered office:
Rutherford House
Nottingham Science and Technology Park
Nottingham
NG7 2PZ
England
Registration Number: 2345696
VAT Number: 526 246 746

Telephone numbers:
+44 (0)115 951 88 00 (main)

For other office locations see:
http://www.romaxtech.com/Contact
=================================
===============
E-mail:
Website:
www.romaxtech.com
=================================

================
Confidentiality Statement
This transmission is for the addressee only and contains information that is confidential and privileged.
Unless you are the named addressee, or authorised to receive it on behalf of the addressee
you may not copy or use it, or disclose it to anyone else.
If you have received this transmission in error please delete from your system and contact the sender. Thank you for your cooperation.
=================================================

В списке pgsql-performance по дате сообщения:

От: Ilya Kosmodemiansky
Дата:
Сообщение: Re: Why shared_buffers max is 8GB?
От: Josh Berkus
Дата:
Сообщение: Re: Connection pooling - Number of connections