Re: 8.0 logging question - Mailing list pgsql-general

From Ed L.
Subject Re: 8.0 logging question
Date
Msg-id 200409241152.59273.pgsql@bluepolka.net
Whole thread Raw
In response to 8.0 logging question  ("Ed L." <pgsql@bluepolka.net>)
List 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


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: pg_dump: what is advantage with schema and data dumps?
Next
From: Paul Tillotson
Date:
Subject: Re: books/sites for someone really learning PG's advanced