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:46:41 +0100
Message-ID: <1131342401.5877.27.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>
Hi Christopher,
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.
But my initial question was about a query that does not produce data at
all (well, a response from the server saying it is finished). I broke
that query off after several hours.
I am now running the query from my initial question with psql (now for
>1 hour, in a transaction, fsyn off).
Some statistics :
uptime:
06:35:55 up 9:47, 6 users, load average: 7.08, 7.21, 6.08
iostat -x -k 1 (this output appears to be representative):
avg-cpu: %user %nice %sys %iowait %idle
1.00 0.00 0.50 98.51 0.00
Device: sda sdb
rrqm/s 0.00 0.00
wrqm/s 14.00 611.00
r/s 0.00 1.00
w/s 3.00 201.00
rsec/s 0.00 32.00
wsec/s 136.00 6680.00
rkB/s 0.00 16.00
wkB/s 68.00 3340.00
avgrq-sz 45.33 33.23
avgqu-sz 0.00 145.67
await 0.67 767.19
svctm 0.67 4.97
%util 0.20 100.30
--
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: <1131342401.5877.27.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