Re: suggestion: log_statement = sample

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: suggestion: log_statement = sample
Date: 2009-07-20 18:09:46
Message-ID: 1248113386.32370.17.camel@jd-laptop.pragmaticzealot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2009-07-20 at 13:46 -0400, Bill Moran wrote:
> In response to "Joshua D. Drake" <jd(at)commandprompt(dot)com>:

> > It depends on the system. I have seen even big systems take a huge hit
> > by full logging due to transactional velocity.
>
> Perhaps I'm just in a foul mood today, but I feel like people are picking

Possibly. :)

> my emails apart to make me the bad guy. Note that you trimmed out a key
> part of what I said here:

Right. I didn't have issue with the rest of your email. Its just the
idea what the person said was ridiculous.

>
> "Have you benchmarked the load it creates under your workload?"

Which is certainly a valid question.

>
> Perhaps I should have explicitly said, "There are likely some cases where
> this statement isn't true, so you should benchmark your specific load
> case, but you don't mention that you've done that."
>
> Or, perhaps I should just abstain from posting to mailing lists when I'm
> in a foul mood ...

It has certainly gotten me in trouble more than once. There is a reason
they say, "Don't go JD".

Joshua D. Drake

>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Mead 2009-07-20 19:01:07 Log timings on Windows 64
Previous Message Bill Moran 2009-07-20 17:46:02 Re: suggestion: log_statement = sample