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.Kraaijeveld@Askesis.nl
web: www.askesis.nl