Re: Function to know last log write timestamp

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Function to know last log write timestamp
Дата
Msg-id 20140814184005.GI28982@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: Function to know last log write timestamp  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Function to know last log write timestamp  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
On 2014-08-14 14:37:22 -0400, Robert Haas wrote:
> On Thu, Aug 14, 2014 at 2:21 PM, Andres Freund <andres@2ndquadrant.com> wrote:
> > On 2014-08-14 14:19:13 -0400, Robert Haas wrote:
> >> That's about the idea. However, what you've got there is actually
> >> unsafe, because shmem->counter++ is not an atomic operation.  It reads
> >> the counter (possibly even as two separate 4-byte loads if the counter
> >> is an 8-byte value), increments it inside the CPU, and then writes the
> >> resulting value back to memory.  If two backends do this concurrently,
> >> one of the updates might be lost.
> >
> > All these are only written by one backend, so it should be safe. Note
> > that that coding pattern, just without memory barriers, is all over
> > pgstat.c
> 
> Ah, OK.  If there's a separate slot for each backend, I agree that it's safe.
> 
> We should probably add barriers to pgstat.c, too.

Yea, definitely. I think this is rather borked on "weaker"
architectures. It's just that the consequences of an out of date/torn
value are rather low, so it's unlikely to be noticed.

Imo we should encapsulate the changecount modifications/checks somehow
instead of repeating the barriers, Asserts, comments et al everywhere.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: B-Tree support function number 3 (strxfrm() optimization)
Следующее
От: Larry White
Дата:
Сообщение: Re: jsonb format is pessimal for toast compression