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