| From: | Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pgsql-Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Performance PG 8.0 on dual opteron / 4GB / 3ware |
| Date: | 2005-11-07 05:04:57 |
| Message-ID: | 1131339897.5877.12.camel@Panoramix |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, 2005-11-07 at 12:37 +0800, Christopher Kings-Lynne wrote:
> > Now *I* am confused. What does PgAdmin do more than giving the query to
> > the database?
>
> It builds it into the data grid GUI object.
Is that not the difference between the total query runtime and the data
retrieval runtime (see below)?
-- Executing query:
select objectid from prototype.orders
Total query runtime: 78918 ms.
Data retrieval runtime: 188822 ms.
1104379 rows retrieved.
--
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 | Dennis Bjorklund | 2005-11-07 05:44:23 | Re: 8.1 iss |
| Previous Message | Christopher Kings-Lynne | 2005-11-07 04:37:31 | Re: Performance PG 8.0 on dual opteron / 4GB / 3ware |