On Sun, 2009-08-30 at 09:03 +0300, Heikki Linnakangas wrote:
> The Hot Standby thing has been discussed, but no-one has actually posted
> a patch which does the locking correctly, where the ProcArrayLock is
> held while the SnapshotData WAL record is inserted. So there is no
> evidence that it's actually a problem, we might be making a mountain out
> of a molehill. It will have practically no effect on throughput, given
> how seldom SnapshotData records are written (once per checkpoint), but
> if it causes a significant bump to response times, that might be a problem.
> This is a good idea to keep in mind, but right now it feels like a
> solution in search of a problem.
The most important thing is to get HS committed and to do that I think
it is important that I show you I am willing to respond to review
comments. So I will implement it the way you propose and defer any
further discussion about lock contention. The idea here is a simple fix
and very easy enough to return to later, if we need it.
Simon Riggs www.2ndQuadrant.com
In response to
pgsql-hackers by date
|Next:||From: Grzegorz Jaskiewicz||Date: 2009-08-30 13:26:32|
|Subject: Re: clang's static checker report.|
|Previous:||From: Tatsuo Ishii||Date: 2009-08-30 12:01:55|
|Subject: PQexecPrepared() behavior|