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