From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | "Magnus Naeslund(f)" <mag(at)fbab(dot)net> |
Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: 7.4 Wishlist |
Date: | 2002-12-02 23:29:24 |
Message-ID: | 1038871764.5193.3.camel@rh72.home.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers |
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(at)tm(dot)ee>
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Naeslund(f) | 2002-12-02 23:39:23 | Re: 7.4 Wishlist |
Previous Message | Stephan Szabo | 2002-12-02 22:51:20 | Re: 7.4 Wishlist |
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Naeslund(f) | 2002-12-02 23:39:23 | Re: 7.4 Wishlist |
Previous Message | Stephan Szabo | 2002-12-02 22:51:20 | Re: 7.4 Wishlist |
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Naeslund(f) | 2002-12-02 23:39:23 | Re: 7.4 Wishlist |
Previous Message | Matthew T. O'Connor | 2002-12-02 22:54:11 | Re: Auto Vacuum Daemon (again...) |