From: Andreas Pflug <pgadmin@pse-consulting.de>
To: Dave Page <dpage@vale-housing.co.uk>
Cc: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
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 17:45:31 +0000
Message-ID: <436F92BB.7040807@pse-consulting.de> (raw)
In-Reply-To: <E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC396C@ratbert.vale-housing.co.uk>
References: <E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC396C@ratbert.vale-housing.co.uk>
Dave Page wrote:
>>
>>
>>Now *I* am confused. What does PgAdmin do more than giving
>>the query to
>>the database?
>
>
> Nothing - it just uses libpq's pqexec function. The speed issue in
> pgAdmin is rendering the results in the grid which can be slow on some
> OS's due to inefficiencies in some grid controls with large data sets.
> That's why we give 2 times - the first is the query runtime on the
> server, the second is data retrieval and rendering (iirc, it's been a
> while).
yrnc.
Query runtime includes data transfer to the client, i.e. until libpq
returns the set, second time is retrieving data from libpq and rendering.
Regards,
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: pgadmin@pse-consulting.de, dpage@vale-housing.co.uk, J.Kraaijeveld@Askesis.nl, tgl@sss.pgh.pa.us
Subject: Re: Performance PG 8.0 on dual opteron / 4GB / 3ware
In-Reply-To: <436F92BB.7040807@pse-consulting.de>
* 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