Re: Log a sample of transactions

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Log a sample of transactions
Дата
Msg-id CA+TgmoZvTmJ24N3LRwykaLpYcLOrD9H_hah-KtWnGLTG_Y875A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Log a sample of transactions  (Adrien NAYRAT <adrien.nayrat@anayrat.info>)
Список pgsql-hackers
On Fri, Jan 18, 2019 at 8:23 AM Adrien NAYRAT
<adrien.nayrat@anayrat.info> wrote:
> On 1/18/19 9:03 AM, Peter Eisentraut wrote:
> > But if you have trouble with a specific transaction, how will a setting
> > help that randomly logs transactions, not necessarily the one you are
> > concerned about?
>
> Yes, it assumes your application performs same type of transaction.
> Maybe the use case is too specific to have this feature in core?

It doesn't sound too crazy to me.  Say you log a sample of statements.
But then you're like, wow, this is hard to interpret, because I don't
know what happened earlier in the transaction.  So then you use this
feature instead.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Protect syscache from bloating with negative cache entries
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: proposal - plpgsql unique statement id