Have you tuned PG? You can run pgtune, http://pgfoundry.org/projects/pgtune, and it'll set sizes for postgresql.conf based on the resources available on the postgres server. -- Later, Darin
On Thu, Oct 24, 2013 at 11:55 AM, David Mesler <david.mes...@gmail.com> wrote: > 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 with 128GB of RAM, 16 physical cpu > cores, and a 500GB ssd for the database. I can point one or two of my puppet > masters at puppetdb with reasonable enough performance, but anymore and > commands start stacking up in the puppetdb command queue and agents start > timing out. (Actually, even with just one puppet master using puppetdb I > still have occasional agent timeouts.) Is one postgres server not going to > cut it? Do I need to look into clustering? I'm sure some of you must run > puppetdb in larger environments than this, any tips? > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to puppet-users+unsubscr...@googlegroups.com. > To post to this group, send email to puppet-users@googlegroups.com. > Visit this group at http://groups.google.com/group/puppet-users. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscr...@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
