Re: Log a sample of transactions

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Log a sample of transactions
Дата
Msg-id 6eb78524-6871-4914-6ce7-f88ed54d811e@2ndquadrant.com
обсуждение исходный текст
Ответ на Log a sample of transactions  (Adrien Nayrat <adrien.nayrat@anayrat.info>)
Ответы Re: Log a sample of transactions  (Adrien Mobile <adrien.nayrat@anayrat.info>)
Список pgsql-hackers
On 12/12/2018 22:32, Adrien Nayrat wrote:
> Per idea of Nikolay Samokhvalov[1] I propose this patch to add the possibility
> to log all statements from a fraction of transactions.
> 
> I have several questions:
>   * Do we want this feature?

It's not clear to me what the use is.  The per-statement sampling allows
you to capture slow queries without overwhelming the logs.  We don't
have any logging of slow transactions or any other transaction scope
logging, so what will this sample?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: don't create storage when unnecessary
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_dump multi VALUES INSERT