Skip site navigation (1)Skip section navigation (2)
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+7gBraJ=4j+Fpj5CfFcpyvxxP6i1J6vOrKVrHAKxFiA6Q@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: <http://docs.FreeBSD.org/cgi/mid.cgi?CAKoxK+7gBraJ=4j+Fpj5CfFcpyvxxP6i1J6vOrKVrHAKxFiA6Q>