From: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Pgsql-Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Performance PG 8.0 on dual opteron / 4GB / 3ware |
Date: | 2005-11-07 04:25:59 |
Message-ID: | 1131337559.5877.7.camel@Panoramix |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi Tom,
On Sun, 2005-11-06 at 15:26 -0500, Tom Lane wrote:
> I'm confused --- where's the 82sec figure coming from, exactly?
>From actually executing the query.
>From PgAdmin:
-- Executing query:
select objectid from prototype.orders
Total query runtime: 78918 ms.
Data retrieval runtime: 188822 ms.
1104379 rows retrieved.
> We've heard reports of performance issues in PgAdmin with large
> result sets ... if you do the same query in psql, what happens?
jkr(at)Panoramix:~/postgresql$ time psql muntdev -c "select objectid from
prototype.orders" > output.txt
real 0m5.554s
user 0m1.121s
sys 0m0.470s
Now *I* am confused. What does PgAdmin do more than giving the query to
the database?
(BTW: I have repeated both measurements and the numbers above were all
from the last measurement I did and are about average)
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2005-11-07 04:37:31 | Re: Performance PG 8.0 on dual opteron / 4GB / 3ware |
Previous Message | Tom Lane | 2005-11-06 20:26:13 | Re: Performance PG 8.0 on dual opteron / 4GB / 3ware |