Date: Tue, 5 May 2015 12:13:12 +0200 From: Luca Ferrari <fluca1978@infinito.it> To: opendaddy@hushmail.com Cc: freebsd-questions <freebsd-questions@freebsd.org> Subject: Re: Rails app slow after PostgreSQL inactivity Message-ID: <CAKoxK%2B7gBraJ=4j%2BFpj5CfFcpyvxxP6i1J6vOrKVrHAKxFiA6Q@mail.gmail.com> In-Reply-To: <20150502201813.91B9E42420@smtp.hushmail.com> References: <20150502201813.91B9E42420@smtp.hushmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Ciao, On Sat, May 2, 2015 at 10:18 PM, <opendaddy@hushmail.com> wrote: > Could this be related to FreeBSD (DigitalOcean)? Are my PostgreSQL workers are going dormant? Do I need a cron script to act as a little ping pong ball bouncing back and forth making sure everybody's awake? > Checking on the PostgreSQL side I would try enabling log_min_duration_statement to see if there is a problematic query that is causing some issue, as well as a few other log_ options (see http://www.postgresql.org/docs/current/static/runtime-config-logging.html). Have you tried to reproduce the query yourself to see (maybe with explain) what is going on? Are there processes running on the background that can slow down the system (e.g., autovacuum)? Hope this helps. Luca
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAKoxK%2B7gBraJ=4j%2BFpj5CfFcpyvxxP6i1J6vOrKVrHAKxFiA6Q>