Magnus Naeslund(f) kirjutas T, 03.12.2002 kell 03:18:
> It looks like it (7.2.x):
>
> # time psql genline -c "select id from xxxx" > /dev/null
> real 0m0.694s
> user 0m0.147s
> sys 0m0.025s
> # time psql genline -c "select id,id||'/'||(select count(*) from xxxx)
> as x from xxxx" > /dev/null
>
> real 0m2.202s
> user 0m0.263s
> sys 0m0.040s
>
> # time psql genline -c "select id,(select count(*) from bildsekvens) as
> x from xxxx" > /dev/null
>
> real 0m1.479s
> user 0m0.254s
> sys 0m0.047s
what is the time for
select id,x
from xxxx,
(select count(*) as x from bildsekvens) c ;
> They were taken from a busy system, but i ran the several times showing
> about the same result.
>
> Magnus
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Hannu Krosing <[EMAIL PROTECTED]>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
