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

Re: Confused by 'timing' results

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: A J <s5aly(at)yahoo(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Confused by 'timing' results
Date: 2010-09-02 18:06:43
Message-ID: 27124.1283450803@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
A J <s5aly(at)yahoo(dot)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

In response to

Responses

pgsql-admin by date

Next:From: A JDate: 2010-09-02 18:10:45
Subject: Re: Confused by 'timing' results
Previous:From: Scott MarloweDate: 2010-09-02 17:56:56
Subject: Re: Confused by 'timing' results

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