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

Re: Query slow as Function

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query slow as Function
Date: 2012-02-18 17:32:55
Message-ID: 20120218173255.GA29781@tux (view raw or flat)
Thread:
Lists: pgsql-performance
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Andreas Kretschmer <akretschmer(at)spamfence(dot)net> writes:
> > You can check the plan with the auto_explain - Extension, and you can
> > force the planner to create a plan based on the actual input-value by
> > using dynamic SQL (EXECUTE 'your query string' inside the function)
> 
> Steve *is* using EXECUTE, so that doesn't seem to be the answer.  I'm

Ohhh yes, my fault, sorry...


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

In response to

pgsql-performance by date

Next:From: Merlin MoncureDate: 2012-02-20 17:32:06
Subject: Re: Query slow as function
Previous:From: Tom LaneDate: 2012-02-18 17:20:36
Subject: Re: Query slow as Function

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