Re: Performance PG 8.0 on dual opteron / 4GB / 3ware

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(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl