Sv: RE: Transactions

[Andreas Joseph Krogh <andreas@xxxxxxxxxx>]

På tirsdag 09. april 2019 kl. 11:56:28, skrev Karl Martin Skoldebrand <KS0C77263@xxxxxxxxxxxxxxxx>:

How much impact on performance and disk space would this or

set log_min_duration_statement=0

have?

 

I have no idea as to how common this is, or when it happens, so it would need to run until this reported again (or some reasonable time if it doesn’t happen).

Well, the answer here is of course "it depends"...

If you have lots of activity the logs will fill up quite quickly, but you can easily test this in production and just turn off logging again by setting it to 'none' and reload settings (no need to restart).

 

You can also only log modifications by setting

log_statement = 'mod'

 

Also watch out for triggers modifying stuff.

 

--

Andreas Joseph Krogh

CTO / Partner - Visena AS

Mobile: +47 909 56 963

andreas@xxxxxxxxxx

www.visena.com