From: A J <s5aly@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Confused by 'timing' results
Date: Thu, 2 Sep 2010 11:10:45 -0700 (PDT)
Message-ID: <825153.47733.qm@web120009.mail.ne1.yahoo.com> (raw)
In-Reply-To: <27124.1283450803@sss.pgh.pa.us>
References: <788866.21140.qm@web120020.mail.ne1.yahoo.com>
<4C7D00330200002500034ED2@gw.wicourts.gov>
<19320.56933.qm@web120013.mail.ne1.yahoo.com>
<AANLkTi=6k6AbmBcqkVCKgNSiogVfQmP+iOC8FgA6+e5J@mail.gmail.com>
<529329.89885.qm@web120007.mail.ne1.yahoo.com>
<4C7F8F2A0200002500035037@gw.wicourts.gov>
<294404.58402.qm@web120007.mail.ne1.yahoo.com>
<27124.1283450803@sss.pgh.pa.us>
The performance as seen from the clients dropped substantially after turning on
the extra logging. The numbers were real but the performance dropped
significantly.
All the log related settings in postgresql.conf are below:
log_destination = 'stderr' # Valid values are combinations of
#log_directory = 'pg_log' # directory where log files are written,
#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
#log_truncate_on_rotation = off # If on, an existing log file of the
#log_rotation_age = 1d # Automatic rotation of logfiles will
#log_rotation_size = 10MB # Automatic rotation of logfiles will
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
#log_min_messages = warning # values in order of decreasing detail:
#log_error_verbosity = default # terse, default, or verbose messages
#log_min_error_statement = error # values in order of decreasing detail:
log_min_duration_statement = 0 # -1 is disabled, 0 logs all statements
log_checkpoints = on
#log_connections = off
#log_disconnections = off
#log_duration = off
#log_hostname = off
log_line_prefix = '%t ' # special values:
#log_lock_waits = off # log lock waits >= deadlock_timeout
log_statement = 'none' # none, ddl, mod, all
#log_temp_files = -1 # log temporary files equal or larger
#log_timezone = unknown # actually, defaults to TZ environment
#log_parser_stats = off
#log_planner_stats = off
#log_executor_stats = off
#log_statement_stats = off
#log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and
________________________________
From: Tom Lane <tgl@sss.pgh.pa.us>
To: A J <s5aly@yahoo.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>; Scott Marlowe
<scott.marlowe@gmail.com>; pgsql-admin@postgresql.org
Sent: Thu, September 2, 2010 2:06:43 PM
Subject: Re: [ADMIN] Confused by 'timing' results
A J <s5aly@yahoo.com> writes:
> On second try, by trying to log to log_directory/log_filename by
> setting log_min_duration_statement=0, seems to be doing something weird. The
> durations are very very high in the file and cannot be true.
You're not being very clear here. Did the logged durations not
correspond to reality? Or did the performance as seen from the clients
drop substantially when you turned on extra logging? Also, exactly
how are you doing logging (ie, what are your settings for
log_destination and related parameters)?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: s5aly@yahoo.com, tgl@sss.pgh.pa.us, Kevin.Grittner@wicourts.gov, scott.marlowe@gmail.com
Subject: Re: Confused by 'timing' results
In-Reply-To: <825153.47733.qm@web120009.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox