On 18 August 2009 at 16:18 Tom Lane wrote:
> Simon, this concept is completely broken, as far as I can tell.
Thanks for the precise example.
Yes, I agree it is not going to work when there could be more than one row
version in the relation. Which doesn't leave useful wriggle room, so not
pu
On 19 August 2009 at 00:09 Josh Berkus wrote:
> When we discussed Hot Standby at pgCon 2008, we discussed the
> possibility of stopping the replications stream whenever a VACUUM came
> through until any queries currently running on the slave completed. Did
> that approach turn out to be comple
On 21 August 2009 at 10:18 Jeff Janes wrote:
> The effect of this seems to be that when WALInsertLock is busy, group
> commits are suppressed.
Agreed, but its not a place to look at just yet since this is changing as part
of sync rep patch.
We do need to change this to make group commit work
One of the problems with Hot Standby is that a long running query on the standby
can conflict with VACUUMed rows on the primary, causing queries to be cancelled.
I've been looking at this problem for about a year now from various angles. Jeff
Jane's recent thoughts on procarray scalability hav
