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
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? |