Sv: RE: Transactions
På tirsdag 09. april 2019 kl. 11:56:28, skrev Karl Martin Skoldebrand <KS0C77263@TechMahindra.com>:
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
Вложения
В списке pgsql-general по дате отправления: