Re: [GENERAL] shared_buffers formula

2015-03-04 Thread Scott Marlowe
On Wed, Mar 4, 2015 at 4:50 AM, Bill Moran wrote: > On Wed, 4 Mar 2015 14:05:09 +0400 > Alexander Shutyaev wrote: > >> Thanks for the answer. Now, given this info I've calculated that our >> postgresql should occupy approx. 30,53 GB while the server has 125 GB of >> RAM. However we often see in t

Re: [GENERAL] shared_buffers formula

2015-03-04 Thread Francisco Olarte
Hi Alexander: On Wed, Mar 4, 2015 at 11:05 AM, Alexander Shutyaev wrote: > Thanks for the answer. Now, given this info I've calculated that our > postgresql should occupy approx. 30,53 GB while the server has 125 GB of > RAM. However we often see in top that there is very little free memory and

Re: [GENERAL] shared_buffers formula

2015-03-04 Thread Bill Moran
On Wed, 4 Mar 2015 14:05:09 +0400 Alexander Shutyaev wrote: > Thanks for the answer. Now, given this info I've calculated that our > postgresql should occupy approx. 30,53 GB while the server has 125 GB of > RAM. However we often see in top that there is very little free memory and > even swap is

Re: [GENERAL] shared_buffers formula

2015-03-04 Thread Andres Freund
Hi, On 2015-03-04 14:05:09 +0400, Alexander Shutyaev wrote: > Thanks for the answer. Now, given this info I've calculated that our > postgresql should occupy approx. 30,53 GB while the server has 125 GB of > RAM. However we often see in top that there is very little free memory and > even swap is

Re: [GENERAL] shared_buffers formula

2015-03-04 Thread Alexander Shutyaev
Thanks for the answer. Now, given this info I've calculated that our postgresql should occupy approx. 30,53 GB while the server has 125 GB of RAM. However we often see in top that there is very little free memory and even swap is used. What could be the reason of postgres using so much memory? Tha

Re: [GENERAL] shared_buffers formula

2015-03-03 Thread Andres Freund
On 2015-03-03 15:06:54 +0400, Alexander Shutyaev wrote: > Recently we've been having problems with swap on our postgresql server. It > has 125GB of RAM. We've decided to calculate it's memory consumption. To do > this we've used the formulas from the official docs [1]. Note that I think those form

[GENERAL] shared_buffers formula

2015-03-03 Thread Alexander Shutyaev
Hello all! Recently we've been having problems with swap on our postgresql server. It has 125GB of RAM. We've decided to calculate it's memory consumption. To do this we've used the formulas from the official docs [1]. However there is one parameter that seems strange - Shared disk buffers. Accord