Re: [PATCHES] Patch to log usage of temporary

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
Cc: Bill Moran <wmoran(at)collaborativefusion(dot)com>, pgsql-patches(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] Patch to log usage of temporary
Date: 2007-01-12 19:12:48
Message-ID: 200701121912.l0CJCmS11155@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Guillaume Smet wrote:
> Hi all,
>
> Sorry for arriving so late into the discussion.
>
> I don't know if it's possible but it could be useful to have the text
> of the query which required the creation of the temporary files as an
> additional DETAIL line. At least, if it's possible to have it in this
> part of the code.
>
> Thoughts?

We have the ability to conditionally print statements based on error
level, but LOG isn't a valid level for log_min_error_statement.

We could add a parameter that few people would use, but the right way to
do this is to log all queries.

We do not allow unlimited logging control or the system would be too
complex.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Guillaume Smet 2007-01-12 19:23:21 Re: [PATCHES] Patch to log usage of temporary files
Previous Message Gurjeet Singh 2007-01-12 19:03:52 Re: SPAR Simple PostgreSQL AddOn Replication System

Browse pgsql-patches by date

  From Date Subject
Next Message Guillaume Smet 2007-01-12 19:23:21 Re: [PATCHES] Patch to log usage of temporary files
Previous Message Simon Riggs 2007-01-12 17:58:53 Re: [HACKERS] [PATCHES] Patch to log usage oftemporary files