| 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: | Whole Thread | Raw Message | 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? |