Re: Reducing ClogControlLock contention

Поиск
Список
Период
Сортировка
От Jesper Pedersen
Тема Re: Reducing ClogControlLock contention
Дата
Msg-id 55FC518F.4070002@redhat.com
обсуждение исходный текст
Ответ на Re: Reducing ClogControlLock contention  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: Reducing ClogControlLock contention  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On 08/31/2015 07:34 AM, Amit Kapila wrote:
> I have updated the patch (attached with mail) to show
> you what I have in mind.
>

I havn't been able to get a successful run with _v5 using pgbench.

TransactionIdSetStatusBit assumes an exclusive lock on CLogControlLock 
when called, but that part is removed from TransactionIdSetPageStatus now.

I tried an
  if (!LWLockHeldByMe(CLogControlLock))  {      LWLockAcquire(CLogControlLock, LW_EXCLUSIVE);      mode = LW_EXCLUSIVE;
}
 

approach, but didn't get further. Plus that probably isn't the best way, 
since we will traverse all LWLock's, and we need to account for cases w/ 
and w/o sub-transactions, e.g. multiple calls to 
TransactionIdSetStatusBit within the CLogControlLock exclusive boundary.

Best regards, Jesper




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jesper Pedersen
Дата:
Сообщение: Re: Speed up Clog Access by increasing CLOG buffers
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: extend pgbench expressions with functions