Re: 8.0 logging question

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 8.0 logging question
Date: 2004-09-24 17:52:59
Message-ID: 200409241152.59273.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday September 24 2004 11:45, Ed L. wrote:
>
> They appear to be coming from the saveplan calls in Slony's
> src/backend/slony1_funcs.c (attached) for sl_log_1 and sl_log_2. Jan
> says "you never see the real execution of saved SPI plans in the log."
> Here's what I see in my log resulting from a simple insert with
> log_error_verbosity = default and logging all:

Correction, that's with log_statement = 'mod'.

On a related note, I see that even though I have log_statement = 'mod' and
log_duration = 'true', we are logging the durations for all queries, not
just those that modify data. That doesn't make much sense; there is no
information there to know what the duration was for.

Ed

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Tillotson 2004-09-24 18:39:11 Re: books/sites for someone really learning PG's advanced
Previous Message Joshua D. Drake 2004-09-24 17:40:14 Re: pg_dump: what is advantage with schema and data dumps?