Hannu Krosing <[EMAIL PROTECTED]> wrote: > 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 ; > > >
time psql genline -c "select id,x from xxxx, (select count(*) as x from xxxx) c ;" > /dev/null real 0m1.354s user 0m0.268s sys 0m0.028s The xxxx and the other table is the same table, sorry i screwed up in the last cut'n'paste operation. As i said it's a loaded system, the figures vary a little bit between runs. Magnus ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html