Re: [PERFORM] Big Memory Boxes and pgtune

2016-10-28 Thread Joshua D. Drake
On 10/28/2016 08:44 AM, Warner, Gary, Jr wrote: I've recently been blessed to move one of my databases onto a huge IBM P8 computer. Its a power PC architecture with 20 8-way cores (so postgres SHOULD believe there are 160 cores available) and 1 TB of RAM. I've always done my postgres tuning

Re: [PERFORM] Big Memory Boxes and pgtune

2016-10-28 Thread Kevin Grittner
On Fri, Oct 28, 2016 at 10:44 AM, Warner, Gary, Jr wrote: > I've recently been blessed to move one of my databases onto a > huge IBM P8 computer. Its a power PC architecture with 20 8-way > cores (so postgres SHOULD believe there are 160 cores available) > and 1 TB of RAM. > So . . . what woul

[PERFORM] Big Memory Boxes and pgtune

2016-10-28 Thread Warner, Gary, Jr
I've recently been blessed to move one of my databases onto a huge IBM P8 computer. Its a power PC architecture with 20 8-way cores (so postgres SHOULD believe there are 160 cores available) and 1 TB of RAM. I've always done my postgres tuning with a copy of "pgtune" which says in the output: