Re: Re: VACUUM and 24/7 database operation

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: Tiger Technologies <lists(at)tigertech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: VACUUM and 24/7 database operation
Date: 2001-01-24 10:28:19
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 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

"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(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight
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

Browse pgsql-general by date

  From Date Subject
Next Message Kogotkov, Vyacheslav 2001-01-24 10:59:20 Can't connect to anonCVS !
Previous Message Thomas T. Thai 2001-01-24 09:33:45 PostgreSQL: Introduction and Concepts by Bruce Momjian