On 10/11/2011 11:23 AM, AA wrote:
hey all
trying to find non optimized queries and want to use this logging
feature, however postgresql seems to write every query to log.
my conf is as follows...
log_min_duration_statement = 450
...
What durations are showing in the log? Are lots/all of the
hey all
trying to find non optimized queries and want to use this logging feature,
however postgresql seems to write every query to log.
my conf is as follows
log_destination = 'csvlog'
logging_collector = on
log_directory = '/usr/local/pgb/pg_log'
log_rotation_size = 100MB
#syslog_facility = 'LO
Hi Scott/Kevin,
Everything got recovered with pg_resetxlog with appropriate -m, -x, -O and -l
options set appropriately described in
"http://www.postgresql.org/docs/8.2/static/app-pgresetxlog.html";. We had lost 4
tables, which were insignificant (compared to losing everything), and did a
sani
