Re: Status of autovacuum and the sporadic stats failures ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Status of autovacuum and the sporadic stats failures ?
Дата
Msg-id 21268.1170799067@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Status of autovacuum and the sporadic stats failures ?  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> I'm tempted to propose replacing the fixed sleep with a short plpgsql
>> function that sleeps for a second, checks to see if the stats have
>> changed, repeats if not; giving up only after perhaps 30 seconds.
>> 
>> It'd be interesting to try to gather stats on the length of the delay
>> taken, but I don't see a good way to do that within the current
>> regression-test infrastructure.

> Have it log something that will appear on the postmaster log but not the 
> client log? Buildfarm members mostly post their complete postmaster 
> logs, and we could postprocess those.

Or even just eyeball them.  Good idea --- I'll do it as soon as I get a
chance to catch my breath.  Today's a bit busy :-(

Or if someone else wants to run with the idea, go for it.
        regards, tom lane


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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: proposed todo: use insert/update returning anywhere a table is allowed
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: proposed todo: use insert/update returning anywhere a table is allowed