Re: 7.4 Wishlist

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>