Re: Status of autovacuum and the sporadic stats failures ?

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Status of autovacuum and the sporadic stats failures ?
Дата
Msg-id 45C8F8A0.4010605@dunslane.net
обсуждение исходный текст
Ответ на Re: Status of autovacuum and the sporadic stats failures ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Status of autovacuum and the sporadic stats failures ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Status of autovacuum and the sporadic stats failures ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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.

cheers

andrew



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Add documentation for Windows on how to set an environment
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: proposed todo: use insert/update returning anywhere a table is allowed