Code review comment for lp:~allenap/launchpad/log-statement-none

Revision history for this message
Gavin Panella (allenap) wrote :

Default to not logging any statements when setting up the database. I
think it's basically harmful; it slows things down, takes up huge
amounts of disk space and is unnecessary 99% of the time. It's easy to
turn on again for a session, user or database, e.g.:

  SET log_statement TO 'all';
  ALTER ROLE launchpad SET log_statement TO 'all';
  ALTER DATABASE launchpad_dev SET log_statement TO 'all';

[ http://www.postgresql.org/docs/8.3/static/sql-set.html
  http://www.postgresql.org/docs/8.3/static/sql-alterrole.html
  http://www.postgresql.org/docs/8.3/static/sql-alterdatabase.html ]

It's also possible to trace statements using Storm:

  from storm.tracer import debug; debug(True)

[ https://dev.launchpad.net/Debugging ]

« Back to merge proposal