Skip site navigation (1) Skip section navigation (2)

the cost of logging statements

From: Marcin Krol <mrkafk(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: the cost of logging statements
Date: 2008-10-29 13:37:50
Message-ID: 4908672E.3010203@gmail.com (view raw or flat)
Thread:
Lists: 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

Next:From: A BDate: 2008-11-03 10:04:42
Subject: postgres user can connect but no one else
Previous:From: Alan HodgsonDate: 2008-10-28 21:26:43
Subject: Re: FOREIGN KEY AND INDEXEX

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group