DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=subject:from:to:cc:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding;
	b=jP9AtQ0mFcgL+9xBowo+BAKVXtvVwVQ/wakgSz7z2/W9ojhGXYG1COsar3kfFzmH5JcgYnCpF9gHArFDbmmC9Nl5g2dmxXP7XWpcqoyODnzs9NczVhU6bWwWW8wja9DGNo2bUfqXEJUZyyIDY64S5Vro+akvNWoTn3UTmWls758=
Subject: Re: Slow set-returning functions
From: Marcin =?UTF-8?Q?St=C4=99pnicki?= <mstepnicki@gmail.com>
To: Dean Rasheed <dean_rasheed@hotmail.com>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <BAY113-W336D429DFB9A2E2772E906F23B0@phx.gbl>
References: <BAY113-W283034364555E644CD1765F23C0@phx.gbl>
	<47935C0C.4090908@enterprisedb.com>
	<b42b73150801200725y45600f6end8d234cea4f8ff22@mail.gmail.com>
	<10405.1200853835@sss.pgh.pa.us>
	<BAY113-W336D429DFB9A2E2772E906F23B0@phx.gbl>
Content-Type: text/plain
Date: Sun, 27 Jan 2008 20:16:20 +0100
Message-Id: <1201461380.19607.6.camel@localhost>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit


Dnia 27-01-2008, N o godzinie 17:29 +0000, Dean Rasheed pisze:
> The CONTEXT is very useful, particularly when functions call other
> functions, since it gives the call stack (presumably only for SQL and
> PL/pgSQL functions). For top-level queries I would ideally like the
> CONTEXT to log the SQL being executed, but I couldn't figure out how
> to access that information.
> 
> Anyway, I'd be interested to know if anyone has thought about doing
> anything like this before and if anyone else might find this useful.
> 
> Dean

I'd love to see that. The mentioned PREPARE workaround doesn't seem to
work when executed function calls for example three another (or I don't
know how to use it in such situation) - and is generally painful to
use. 

I'm afraid I can't help you much (besides testing) but I'd be more than
interested in such improvement.

Regards,
Marcin