search for: pgtune

Displaying 2 results from an estimated 2 matches for "pgtune".

Did you mean: gtune
2013 Oct 24
11
Help with scaling puppetdb/postgres
Hello, I''m currently trying to deploy puppetdb to my environment but I''m having difficulties and am unsure on how to proceed. I have 1300+ nodes checking in at 15 minute intervals (3.7 million resources in the population). The load is spread across 6 puppet masters. I requisitioned what I thought would be a powerful enough machine for the puppetdb/postgres server. A machine
2015 Aug 19
0
shared memory - shmmax - shmall - page_size
...ion? should the defaults be set on SHMALL = SHMMAX / 16?? I'm running CentOS Linux release 7.1.1503 (Core), my old database is running CentOS release 6.6 (Final) and I'm seeing the same calculations there too. Can somebody please point me in the right direction, I've had a look at pgtune here http://pgtune.leopard.in.ua/, I will not be using the 'default' calculated configuration that it suggests but I noticed the shmall = shmmax / page_size (4096). I'll benchmark with both calculations but I would really appreciate some confirmation on this. thanks Michael