From: | "Magnus Naeslund(f)" <mag(at)fbab(dot)net> |
---|---|
To: | "Hannu Krosing" <hannu(at)tm(dot)ee> |
Cc: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 7.4 Wishlist |
Date: | 2002-12-02 23:39:23 |
Message-ID: | 078d01c29a5c$0b72b210$f80c0a0a@mnd |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers |
Hannu Krosing <hannu(at)tm(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2002-12-02 23:43:54 | [Fwd: zeit.de based on postgresql] |
Previous Message | Hannu Krosing | 2002-12-02 23:29:24 | Re: 7.4 Wishlist |
From | Date | Subject | |
---|---|---|---|
Next Message | Aasmund Midttun Godal | 2002-12-02 23:50:44 | Re: --with-tcl |
Previous Message | Hannu Krosing | 2002-12-02 23:29:24 | Re: 7.4 Wishlist |
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2002-12-02 23:59:58 | "unofficial" 7.3 RPMs |
Previous Message | Hannu Krosing | 2002-12-02 23:29:24 | Re: 7.4 Wishlist |