Re: temporary statistics option at initdb time

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: temporary statistics option at initdb time
Дата
Msg-id 48B2CB7E.3070507@hagander.net
обсуждение исходный текст
Ответ на Re: temporary statistics option at initdb time  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: temporary statistics option at initdb time  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Magnus Hagander <magnus@hagander.net> writes:
>> Actually, I think maybe not so hard. Attached is a patch that fixes
>> this. It's done by keeping the old filename around. When you change the
>> path, the stats collector will start writing the new file the next time
>> it writes something (which should be max 0.5 seconds later if something
>> is happening). The backends will immediately try to read from the new
>> filename, but if that one is not found, they will switch to reading the
>> old filename. This obviously fails if you change the temp directory
>> twice in less than half a second, but I really don't see a use-case for
>> that...
> 
> I think this is introducing complication and race conditions to solve a
> problem that no one will really care about.  Just let people change the
> filename at SIGHUP and document that doing that on-the-fly may cause
> stats queries to fail for a short interval.

Ok, I'll do it that way.

//Magnus


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: IN, BETWEEN, spec compliance, and odd operator names
Следующее
От: Tom Lane
Дата:
Сообщение: Another refactoring proposal: move stuff into nodes/nodeFuncs.[ch]