Re: Inadequate thought about buffer locking during hot standby replay

Поиск
Список
Период
Сортировка
От Gavin Flower
Тема Re: Inadequate thought about buffer locking during hot standby replay
Дата
Msg-id 50A2902A.1020209@archidevsys.co.nz
обсуждение исходный текст
Ответ на Re: Inadequate thought about buffer locking during hot standby replay  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
On 14/11/12 04:32, Merlin Moncure wrote:
> On Tue, Nov 13, 2012 at 9:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> Ok. It won't help all that much on 9.0, though.
>> Well, it won't help GIST much, but the actually-reported-from-the-field
>> case is in btree, and it does fix that.
>>
>> It occurs to me that if we're sufficiently scared of this case, we could
>> probably hack the planner (in 9.0 only) to refuse to use GIST indexes
>> in hot-standby queries.  That cure might be worse than the disease though.
> if anything, it should be documented.  if you do this kind of thing
> people will stop installing bugfix releases.
>
> merlin
>
>
How about displaying a warning, when people try to use the 'feature', as 
well as document it?

Cheers,
Gavin




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Proposal for Allow postgresql.conf values to be changed via SQL
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Inadequate thought about buffer locking during hot standby replay