Kiriakos Georgiou <kg.postgresql@xxxxxxxxxxxxxx> 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@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
