Re: Displaying accumulated autovacuum cost

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Displaying accumulated autovacuum cost
Дата
Msg-id 1317815012-sup-9022@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Displaying accumulated autovacuum cost  (Greg Smith <greg@2ndQuadrant.com>)
Список pgsql-hackers
Excerpts from Greg Smith's message of mié oct 05 04:02:12 -0300 2011:
> 
> On 09/29/2011 10:40 AM, Alvaro Herrera wrote:
> > I reviewed this patch.  My question for you is: does it make sense to
> > enable to reporting of write rate even when vacuum cost accounting is
> > enabled?  In my opinion it would be useful to do so.  If you agree,
> > please submit an updated patch.
> 
> Presumably you meant to ask if this makes sense to show when cost 
> accounting isn't enabled, because the code doesn't do that right now.  
> No cost accounting, no buffer usage/write rate data as this was submitted.

Yes, sorry, that's what I meant.

> Looks like making this work even in cases where cost accounting isn't on 
> will make the patch a bit larger obtrusive, but it's not unreasonable.  
> Now that you mention it, people who do a manual, full-speed VACUUM would 
> certainly appreciate some feedback on the rate it ran at.  I'll include 
> that in the next update.

Thanks.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: Hamza Bin Sohail
Дата:
Сообщение: Query regarding postgres lock contention - Followup
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [REVIEW] prepare plans of embedded sql on function start