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 CPU etc. and you'll always be increasing your JVM heap also ... Not only that, PostgreSQL will be better for backups, outside querying, better monitoring and will allow you more performance tuning opportunities. On Wed, Feb 6, 2013 at 8:20 PM, Jakov Sosic <[email protected]> wrote: > 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 need to serve, so that PuppetDB in it's default > installation, without pgsql, becomes a bottleneck? What's you're experience? > > > Thank you, > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/puppet-users?hl=en. > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/puppet-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
