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 <hannu@tm.ee>