Re: Why does analyze_new_cluster.sh use sleep? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Why does analyze_new_cluster.sh use sleep?
Date
Msg-id 20120823210545.GB10337@momjian.us
Whole thread Raw
In response to Why does analyze_new_cluster.sh use sleep?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Why does analyze_new_cluster.sh use sleep?
List pgsql-hackers
On Thu, Aug 23, 2012 at 02:17:44AM -0400, Peter Eisentraut wrote:
> The script analyze_new_cluster.sh output by pg_upgrade contains several
> "sleep" calls (see contrib/pg_upgrade/check.c).  What is the point of
> this?  If the purpose of this script is to get the database operational
> again as soon as possible, waiting a few seconds doing nothing surely
> isn't helping.
> 
> I could maybe see the point of waiting a bit between the different
> vacuumdb calls, to catch some breath, but the one before the first call
> to vacuumdb is highly dubious to me.

The sleep is there so the user can read the status message, in case it
scrolls off the screen once the next stage starts.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Is this an appropriate item?
Next
From: Andrew Dunstan
Date:
Subject: Re: 9.2RC1 wraps this Thursday ...