[PERFORM] runtime of the same query in function differs on 2 degree!

2003-10-02 Thread Andriy Tkachuk
= 1062363600) AND (dat 1064955599)) Total runtime: 101.14 msec ^^ So the query is the same as in calc_total(usr,d1,d2) function, but execute time extremely differs. Is it normal? Thanks, Andriy Tkachuk. ---(end of broadcast

Re: [PERFORM] runtime of the same query in function differs on 2

2003-10-03 Thread Andriy Tkachuk
realization of calc_total() on pl/tcl. I use there spi_exec - so the query always regards as dynamic - it always parsed, rewritten, planned but executes fastest much more :) On Fri, 3 Oct 2003, Gaetano Mendola wrote: Andriy Tkachuk wrote: Hi folks. What's wrong with planner that executes my

Re: [PERFORM] IMMUTABLE function's flag do not work: 7.3.4, plpgsql

2003-10-09 Thread Andriy Tkachuk
On Wed, 8 Oct 2003, Tom Lane wrote: Andriy Tkachuk [EMAIL PROTECTED] writes: At second. calc_total() is immutable function: but it seems that it's not cached in one session: It's not supposed to be. but it's written id doc: IMMUTABLE indicates that the function always

Re: [PERFORM] IMMUTABLE function's flag do not work: 7.3.4, plpgsql

2003-10-10 Thread Andriy Tkachuk
On Thu, 9 Oct 2003, Gaetano Mendola wrote: Andriy Tkachuk wrote: On Wed, 8 Oct 2003, Tom Lane wrote: Andriy Tkachuk [EMAIL PROTECTED] writes: At second. calc_total() is immutable function: but it seems that it's not cached in one session: It's not supposed to be. but it's

Re: [PERFORM] IMMUTABLE function's flag do not work: 7.3.4, plpgsql

2003-10-13 Thread Andriy Tkachuk
. ^^ ... ok, mabe i should say constant args as in doc. Anyway, thank you for attention and willing to help. regards, andriy tkachuk (http://imt.com.ua) On Sun, 12 Oct 2003, Gaetano Mendola wrote: Andriy Tkachuk wrote: On Thu, 9 Oct 2003

Re: [PERFORM] One or more processor ?

2003-10-13 Thread Andriy Tkachuk
On Fri, 10 Oct 2003, Bill Moran wrote: johnn wrote: On Fri, Oct 10, 2003 at 12:42:04PM -0400, Bill Moran wrote: 4) It simply isn't practical to expect a single query to execute on multiple processors simultaneously. Do you know of any RDBMS that actually will execute a single