Re: unlogged tables vs. GIST

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: unlogged tables vs. GIST
Дата
Msg-id 6126.1292620676@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: unlogged tables vs. GIST  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: unlogged tables vs. GIST  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
[ hit send too soon ... ]

Robert Haas <robertmhaas@gmail.com> writes:
> Since these bits will only be set/cleared when the buffer mapping is
> changed, can we examine this bit without taking the spinlock?

Only if you're willing for the result to be unreliable.  In the
case of the xlog flush bit, I don't believe an extra locking cycle
should be necessary anyway, as you surely had the lock when you 
found the page to be dirty in the first place.  You could grab the
bit then.  I'm not sure where you envision checking the other bit,
but I doubt it can be all that far removed from a lock acquisition.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: unlogged tables vs. GIST
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: ps_status on fastpath