Re: Log a sample of transactions - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Log a sample of transactions
Date
Msg-id 6eb78524-6871-4914-6ce7-f88ed54d811e@2ndquadrant.com
Whole thread Raw
In response to Log a sample of transactions  (Adrien Nayrat <adrien.nayrat@anayrat.info>)
Responses Re: Log a sample of transactions  (Adrien Mobile <adrien.nayrat@anayrat.info>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: don't create storage when unnecessary
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_dump multi VALUES INSERT