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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Wed, 29 Oct 2008 14:37:50 +0100
  • Message-id: <4908672E.3010203@gmail.com> <text/plain>

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






Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group