Re: Re: VACUUM and 24/7 database operation

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