Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Well, except for bind, all the log output display is zero cost, just a
> > printf(), as I remember.  The only cost that is significant, I think, is
> > the timing of the query, and that is happening for all the setttings
> > discussed.
> 
> On a machine with slow gettimeofday(), measuring duration at all is
> going to hurt, but apparently that is not Guillaume's situation ---
> what's costing him is sheer log volume.  And remember that the
> slow-gettimeofday problem exists mainly on cheap PCs, not server-grade
> hardware.  Based on his experience I'm prepared to believe that there
> is a use-case for logging just the duration for short queries.
> 
> It seems like we should either remove the separate log_duration boolean
> or make it work as he suggests.  I'm leaning to the second answer now.
> What's your vote?

#2, I think, but I am confused if you don't know the query, how valuable
is the log_duration.

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to