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

Re: What is syslog:duration reporting ... ?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: Aldor <an(at)mediaroot(dot)de>, pgsql-admin(at)postgresql(dot)org
Subject: Re: What is syslog:duration reporting ... ?
Date: 2005-08-25 19:55:09
Message-ID: 20050825195508.GA54074@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, Aug 25, 2005 at 03:56:36PM -0300, Marc G. Fournier wrote:
> On Thu, 25 Aug 2005, Aldor wrote:
> >I'm still wondering why you first query takes about 4107.987 ms - this 
> >kind of query has usually have to run much much faster.
> 
> That would work if I were to get really occasional high values in syslog, 
> but this is almost a consist thing over a very short period of time:

Are the updates happening inside a transaction?  Is it possible
that they're being blocked by other transactions that update the
same record around the same time and don't commit immediately?
I can duplicate the results you're seeing by doing that.

-- 
Michael Fuhr

In response to

Responses

pgsql-admin by date

Next:From: Michael FuhrDate: 2005-08-25 19:59:40
Subject: Re: What is syslog:duration reporting ... ?
Previous:From: AldorDate: 2005-08-25 19:32:29
Subject: Re: What is syslog:duration reporting ... ?

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