Re: [PATCHES] Patch to log usage of temporary - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: [PATCHES] Patch to log usage of temporary
Date
Msg-id 200701121912.l0CJCmS11155@momjian.us
Whole thread Raw
In response to Re: [PATCHES] Patch to log usage of temporary files  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Responses Re: [PATCHES] Patch to log usage of temporary files  ("Guillaume Smet" <guillaume.smet@gmail.com>)
List 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@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

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

pgsql-patches by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: [HACKERS] [PATCHES] Patch to log usage oftemporary files
Next
From: "Guillaume Smet"
Date:
Subject: Re: [PATCHES] Patch to log usage of temporary files