Re: 7.4 Wishlist

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