Re: Re: VACUUM and 24/7 database operation - Mailing list pgsql-general

From Oliver Elphick
Subject Re: Re: VACUUM and 24/7 database operation
Date
Msg-id 200101241028.f0OASLq19741@linda.lfix.co.uk
Whole thread Raw
In response to Re: VACUUM and 24/7 database operation  (Tiger Technologies <lists@tigertech.com>)
List pgsql-general
Tiger Technologies wrote:
  >If your site is down two minutes a day, and you have 14,000 unique
  >visitors a week, each of whom requires a database update, that's 20
  >people a week for whom the site isn't working when they arrive.

Since vacuuming is necessary, one solution is to tell the user exactly
what is happening.  People get very fed up with unresponsive servers, but
are much more ready to accept things if they know what is happening.

Just before you start the vacuum, redirect queries to a page that
says:

  "Started database maintenance at <time>; this process normally takes
  about two minutes; time taken so far <mm:ss>.  While you are waiting,
  here are some nice photos to look at."

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "If anyone has material possessions and sees his
      brother in need but has no pity on him, how can the
      love of God be in him?"
                                    I John 3:17



pgsql-general by date:

Previous
From: "Thomas T. Thai"
Date:
Subject: PostgreSQL: Introduction and Concepts by Bruce Momjian
Next
From: "Kogotkov, Vyacheslav"
Date:
Subject: Can't connect to anonCVS !