[Puppet Users] PuppetDB builtin backend performance?

2013-02-06 Thread Jakov Sosic
Hi, I'm using PuppetDB with builtin backend, haven't switched yet to postgresql, and I'm starting to see decrease in performance of my agent runs. I use PuppetDB solely because of exported resources support. How soon should I think about moving to PostgreSQL? How many clients does my master

Re: [Puppet Users] PuppetDB builtin backend performance?

2013-02-06 Thread Ken Barber
I would recommend moving it over now. There are magic numbers I could make up about when to switch etc., but if you want to get it right from the beginning switch now. The problem is HSQLDB stores everything in the RAM in the JVM, and as that gets bigger your JVM garbage collection consumes more

Re: [Puppet Users] PuppetDB builtin backend performance?

2013-02-06 Thread Jakov Sosic
On 02/06/2013 09:48 PM, Ken Barber wrote: I would recommend moving it over now. There are magic numbers I could make up about when to switch etc., but if you want to get it right from the beginning switch now. The problem is HSQLDB stores everything in the RAM in the JVM, and as that gets

Re: [Puppet Users] PuppetDB builtin backend performance?

2013-02-06 Thread Ken Barber
If you like, try the puppetdb module ... it includes support for setting up the postgresql server as well: http://forge.puppetlabs.com/puppetlabs/puppetdb We're really working hard to make it work well (and the postgresql module for that matter) and would love to hear if it works well for you.