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

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-patches by date

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

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