Re: LWLock Queue Jumping
От | Simon Riggs |
---|---|
Тема | Re: LWLock Queue Jumping |
Дата | |
Msg-id | 1251634961.4839.1532.camel@ebony.2ndQuadrant обсуждение исходный текст |
Ответ на | Re: LWLock Queue Jumping (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>) |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: