| Lists: | pgsql-bugs |
|---|
| From: | "Arvind S" <arvindwill(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4773: Logging error |
| Date: | 2009-04-22 13:14:06 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4773
Logged by: Arvind S
Email address: arvindwill(at)gmail(dot)com
PostgreSQL version: 8.1
Operating system: Cent OS
Description: Logging error
Details:
I set log_min_duration_statement to 10000 and restart the postgres. But when
i check the tail to log i am getting all queries. please tell is it bug ?
i have log_statement = all . is there any relation between this and
min_duaration?
| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Arvind S <arvindwill(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4773: Logging error |
| Date: | 2009-04-22 13:29:53 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Arvind S wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4773
> Logged by: Arvind S
> Email address: arvindwill(at)gmail(dot)com
> PostgreSQL version: 8.1
> Operating system: Cent OS
> Description: Logging error
> Details:
>
> I set log_min_duration_statement to 10000 and restart the postgres. But when
> i check the tail to log i am getting all queries. please tell is it bug ?
> i have log_statement = all . is there any relation between this and
> min_duaration?
The queries you are seeing are from log_statement = all. The output of
log_min_duration_statement would be showing you times as well as
queries. The two settings do not control each other.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +