Re: Dividing progress/debug information in pg_standby, and stat before copy - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Dividing progress/debug information in pg_standby, and stat before copy
Date
Msg-id 4B5DE438.1040405@agliodbs.com
Whole thread Raw
In response to Dividing progress/debug information in pg_standby, and stat before copy  (Selena Deckelmann <selenamarie@gmail.com>)
Responses Re: Dividing progress/debug information in pg_standby, and stat before copy  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-hackers
On 1/25/10 9:45 AM, Selena Deckelmann wrote:
> Hi!
> 
> I poked around a little at pg_standby because of some 'cp: file does
> not exist' errors that were cropping up as pg_standby searched around
> for .history files.
> 
> I added a stat that still outputs debugging information but now we
> don't get cp failures, and then added a 'progress' mode. It was a bit
> of a semantic stretch, but '-l' had been used for 'link' in the past.

We discussed this issue at LCA where I encountered these bogus error
messages when I was doing the demo of HS.  I consider Selena's patch to
be a bug-fix for beta of 9.0, not a feature.  Currently the database
reports a lot of false error messages when running in standby mode, and
once we have 1000's more users using standby mode, we're going to see a
lot of related confusion.

The searching for files it doesn't need also delays standby for 15-45s,
so this is a performance fix as well.

--Josh Berkus


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Syntax supplements for SET options
Next
From: Josh Berkus
Date:
Subject: Re: problem with CVS on pgfoundry