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