Skip site navigation (1) Skip section navigation (2)

Re: WIP patch - INSERT-able log statements

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Greg Smith" <gsmith(at)gregsmith(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: WIP patch - INSERT-able log statements
Date: 2007-02-20 08:03:27
Message-ID: 1d4e0c10702200003m3a71b4ceia17963c35952af1c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On 2/20/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Of course, the other side of that coin is that syslog is known to drop
> messages altogether under sufficient load.  (At least on some platforms;
> dunno about yours.)

Yes I know. That's one of the reason why I asked for the bahaviour of
7.4 log_duration back in 8.2. It's a good compromise which allows us
not to lose lines and have a good level of information (at least, the
best we can have). Async IO helps.

Moreover we use syslog to send the log lines via UDP so we know that
it's not perfect. But it works nice most of the time. We know that we
can't log every query (we use a combination of log_duration and
log_min_duration_statement - I patched 8.1 for that) because if we do
so we lose a lot of lines and queries are not consistent but we can't
do it locally with stderr anyway due to I/O. This method has been
reliable for more than a year and our daily reports are consistent.

--
Guillaume

In response to

Responses

pgsql-hackers by date

Next:From: Pavan DeolaseeDate: 2007-02-20 08:10:50
Subject: Re: [HACKERS] HOT WIP Patch - version 2
Previous:From: Hannu KrosingDate: 2007-02-20 07:48:56
Subject: Re: [HACKERS] HOT WIP Patch - version 2

pgsql-patches by date

Next:From: Pavan DeolaseeDate: 2007-02-20 08:10:50
Subject: Re: [HACKERS] HOT WIP Patch - version 2
Previous:From: Hannu KrosingDate: 2007-02-20 07:48:56
Subject: Re: [HACKERS] HOT WIP Patch - version 2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group