So I turned this option on:

log_statement = 'all'

..and it logs queries nicely to PostgreSQL log files. It's great for
diagnostics & query optimization, so I'm thinking loudly - how costly in
terms of performance would it be to have it turned on on a production
system?

Does PostgreSQL do a sync on getting smth to log (like Linux syslog)?

If not, would the cost of that be high (apart from obvious
considerations with disk space)?

Regards,
Marcin Krol

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedOct 29, '08 at 1:38p
activeOct 29, '08 at 1:38p
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Marcin Krol: 1 post

People

Translate

site design / logo © 2022 Grokbase