From: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pgsql-Performance <pgsql-performance@postgresql.org>
Subject: Re: Performance PG 8.0 on dual opteron / 4GB / 3ware
Date: Mon, 07 Nov 2005 06:04:57 +0100
Message-ID: <1131339897.5877.12.camel@Panoramix> (raw)
In-Reply-To: <436EDA0B.8030604@familyhealth.com.au>
References: <1131283854.15471.4.camel@Panoramix>
<25425.1131297440@sss.pgh.pa.us>
<1131305633.5882.17.camel@Panoramix>
<2503.1131308773@sss.pgh.pa.us>
<1131337559.5877.7.camel@Panoramix>
<436EDA0B.8030604@familyhealth.com.au>
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.Kraaijeveld@Askesis.nl
web: www.askesis.nl
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: J.Kraaijeveld@Askesis.nl, chriskl@familyhealth.com.au, tgl@sss.pgh.pa.us
Subject: Re: Performance PG 8.0 on dual opteron / 4GB / 3ware
In-Reply-To: <1131339897.5877.12.camel@Panoramix>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox