Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system)

2017-03-27 Thread Merlin Moncure
On Fri, Mar 24, 2017 at 2:47 PM, Scott Marlowe wrote: > On Fri, Mar 24, 2017 at 3:58 AM, Pietro Pugni wrote: >> Hi there, >> I’m running PostgreSQL 9.6.2 on Ubuntu 16.04.2 TLS (kernel >> 4.4.0-66-generic). Hardware is: >> - 2 x Intel Xeon E5-2690

Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system)

2017-03-24 Thread trafdev
Looks like Postgres will never "use" (visually) more than shared_buffers size of memory. Change it to 48GB, and in your "top" output you will see how memory usage bumped up to this new limit. But it's just a "visual" change, I doubt you'll get any benefits from it. On 03/24/17 02:58,

Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system)

2017-03-24 Thread Shaun Thomas
> What’s wrong with this? There isn’t something wrong in RAM usage? Nope, nothing wrong with RAM usage at all from what you've presented here. Please consider the cut-and-paste you included a bit closer. All of your active threads are utilizing 100% CPU, and are therefore CPU-bound. If there were

Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system)

2017-03-24 Thread Álvaro Hernández Tortosa
On 24/03/17 10:58, Pietro Pugni wrote: Hi there, I’m running PostgreSQL 9.6.2 on Ubuntu 16.04.2 TLS (kernel 4.4.0-66-generic). Hardware is: - 2 x Intel Xeon E5-2690 - 96GB RAM - Software mdadm RAID10 (6 x SSDs) Postgres is used in a sort of DWH application, so all the resources are

Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system)

2017-03-24 Thread Scott Marlowe
On Fri, Mar 24, 2017 at 3:58 AM, Pietro Pugni wrote: > Hi there, > I’m running PostgreSQL 9.6.2 on Ubuntu 16.04.2 TLS (kernel > 4.4.0-66-generic). Hardware is: > - 2 x Intel Xeon E5-2690 > - 96GB RAM > - Software mdadm RAID10 (6 x SSDs) > > Postgres is used in a sort of

Re: [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system)

2017-03-24 Thread Andrew Kerber
As I read this, you have 24G of hugepages, and hugepages enabled for postgres. Can postgres use both standard pages and hugepages at the same time? Seems unlikely to me. On Fri, Mar 24, 2017 at 4:58 AM, Pietro Pugni wrote: > Hi there, > I’m running PostgreSQL 9.6.2 on