Re: Rethinking stats communication mechanisms

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Rethinking stats communication mechanisms
Дата
Msg-id 87mzca6hb3.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Rethinking stats communication mechanisms  (Douglas McNaught <doug@mcnaught.org>)
Ответы Re: Rethinking stats communication mechanisms  (Douglas McNaught <doug@mcnaught.org>)
Список pgsql-hackers
Douglas McNaught <doug@mcnaught.org> writes:

> Yeah, but if you turn on query logging in that case you'll see the
> bajillions of short queries, so you don't need the accurate snapshot
> to diagnose that.

Query logging on a production OLTP machine? a) that would be a huge
performance drain on the production system b) it would produce so much logging
that it would take a significant amount of disk and i/o resources just to
handle and c) you would need to implement special purpose tools just to make
sense of these huge logs.


-- 
greg



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

Предыдущее
От: Douglas McNaught
Дата:
Сообщение: Re: Rethinking stats communication mechanisms
Следующее
От: Arjen van der Meijden
Дата:
Сообщение: Re: [PERFORM] Sun Donated a Sun Fire T2000 to the PostgreSQL