the cost of logging statements - Mailing list pgsql-novice

From Marcin Krol
Subject the cost of logging statements
Date
Msg-id 4908672E.3010203@gmail.com
Whole thread Raw
List pgsql-novice
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




pgsql-novice by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: FOREIGN KEY AND INDEXEX
Next
From: "A B"
Date:
Subject: postgres user can connect but no one else