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 exec

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

2003-10-13 Thread Andriy Tkachuk
h same args. ^^ ... 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 wr

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: > >>&g

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:

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

2003-10-08 Thread Andriy Tkachuk
QUERY PLAN -- Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.00..0.00 rows=1 loops=1) Total runtime: 0.02 msec (2 rows) What i miss? Thanks, Andriy Tkachuk http://www.imt.com.ua ---(end of broadcast)--

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

2003-10-03 Thread Andriy Tkachuk
vious 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. > > > > W

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

2003-10-02 Thread Andriy Tkachuk
R (user_id = 6916799)) AND (dat >= 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.