From: Jerry Sievers <gsievers19@comcast.net>
To: Kiriakos Georgiou <kg.postgresql@olympiakos.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: is it cool to restart servers as preventive maintenance?
Date: Wed, 10 Feb 2016 13:46:35 -0600
Message-ID: <868u2sxs9w.fsf@jerry.enova.com> (raw)
In-Reply-To: <F83C2392-27AD-41D5-9FCE-4C4A2321A2CA@olympiakos.com>
References: <F83C2392-27AD-41D5-9FCE-4C4A2321A2CA@olympiakos.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Kiriakos Georgiou <kg.postgresql@olympiakos.com> writes:
> Hello,
>
> Is it accepted practice to restart a production database on a regular basis (e.g.: once a month) ?
>
> In the last 12 months I have noticed 3-4 instances of database
> flakiness that is cured by restarting. I’ve been using
> PostgreSQL since 2007 and I haven’t seen such issues
> requiring a reboot, but on my current project we do some rather heavy
> duty PostGIS analysis that apparently stresses the system enough to
> occasionally cause this (that’s my theory anyway.)
> I’m beginning to seriously consider restarting servers on a
> monthly basis.
I once took a new DBA position and found them doing a weekly full
restart and clustering several large table.
This went on for a short while until I brought to their attention that
the only problem was long-open transactions :-)
We put in a fix for that problem...
Thus rather than taking production down every Friday night, we went out
partying instead.
Unsophisticated/brute force approach and nobody wins.
YMMV
> regards,
> Kiriakos Georgiou
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, kg.postgresql@olympiakos.com
Subject: Re: is it cool to restart servers as preventive maintenance?
In-Reply-To: <868u2sxs9w.fsf@jerry.enova.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox