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 20:04:46
Message-ID: 200701122004.l0CK4ko01232@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Guillaume Smet wrote:
> On 1/12/07, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > Usually people don't want th query unless they ask for it. One nify
> > trick would be to print the query as DETAIL unless they are already
> > logging queries, but that just seems too complex. If you want the
> > query, why not just log them all?
>
> Because they can't? On a highly loaded production server, people
> usually don't log all the queries.
>
> Anyway, if it's too complicated to implement it, perhaps it's not
> worth it. I'm just curious to see how people will use this information
> if they don't know why the temp file was created.

We have to balance functionality and ease of use. That is the way I
analyze these issue. We usually wait for a few people to request
additional functionality of this type, and then figure out the cleanest
way to implement it.

--
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2007-01-12 20:13:44 Re: [GENERAL] Corrupt database? 8.1/FreeBSD6.0
Previous Message Tom Lane 2007-01-12 19:59:20 Re: [HACKERS] [PATCHES] Patch to log usage of temporary files

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2007-01-12 20:13:44 Re: [GENERAL] Corrupt database? 8.1/FreeBSD6.0
Previous Message Tom Lane 2007-01-12 19:59:20 Re: [HACKERS] [PATCHES] Patch to log usage of temporary files