From: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
---|---|
To: | Kiriakos Georgiou <kg(dot)postgresql(at)olympiakos(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: is it cool to restart servers as preventive maintenance? |
Date: | 2016-02-10 19:46:35 |
Message-ID: | 868u2sxs9w.fsf@jerry.enova.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Kiriakos Georgiou <kg(dot)postgresql(at)olympiakos(dot)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(dot)consulting(at)comcast(dot)net
p: 312.241.7800
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-02-10 20:18:48 | Re: is it cool to restart servers as preventive maintenance? |
Previous Message | Kiriakos Georgiou | 2016-02-10 19:10:19 | is it cool to restart servers as preventive maintenance? |