Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B32666507B2 for ; Wed, 20 Aug 2008 16:56:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07127-06-4 for ; Wed, 20 Aug 2008 16:56:05 -0300 (ADT) X-Greylist: delayed 00:22:43.365515 by SQLgrey-1.7.6 Received: from mail.ecomtecnologia.com.br (200.146.84.186.static.gvt.net.br [200.146.84.186]) by postgresql.org (Postfix) with ESMTP id 9F8A2650833 for ; Wed, 20 Aug 2008 15:53:15 -0300 (ADT) Received: from [192.168.1.35] (unknown [192.168.1.35]) by mail.ecomtecnologia.com.br (Postfix) with ESMTP id CC58579C092 for ; Wed, 20 Aug 2008 15:30:29 -0300 (BRT) Message-ID: <48AC62C1.9070209@ecomtecnologia.com.br> Date: Wed, 20 Aug 2008 15:30:25 -0300 From: =?ISO-8859-1?Q?Andr=E9_Volpato?= User-Agent: Thunderbird 2.0.0.16 (Windows/20080708) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Postgres not using array Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/232 X-Sequence-Number: 31113 Folks, In a fresh Pg8.3.3 box, we created a 3-stripe RAID0 array. The write speed is about 180MB/s, as shown by dd : # dd if=3D/dev/zero of=3D/postgres/base/teste2 bs=3D1024 count=3D5000000 5000000+0 records in 5000000+0 records out 5120000000 bytes (5,1 GB) copied, 28,035 seconds, 183 MB/s BTW, /postgres is $PGDATA ... Unfortunely, we cant figure out why Postgres is not using the disks at al= l. Right now, there are 3 heavy queryes running, and the disks are almost=20 sleeping... The CPU is 100% used since a few hours ago. Can anyone tell why? # dstat ----total-cpu-usage---- -dsk/total- -net/total- ---paging-- ---system-- usr sys idl wai hiq siq|_read _writ|_recv _send|__in_ _out_|_int_ _csw_ 99 1 0 0 0 0| 0 0 | 574B 1710B| 0 0 | 6 55 99 1 0 0 0 0| 0 0 | 290B 770B| 0 0 | 8 48 99 1 0 0 0 0| 0 0 | 220B 540B| 0 0 | 6 44 99 1 0 0 0 0| 0 0 | 354B 818B| 0 0 | 10 50 98 2 0 0 0 0| 0 0 |1894B 4857B| 0 0 | 27 78 100 0 0 0 0 1| 0 0 | 348B 1096B| 0 0 | 12 45 The specs: Intel(R) Pentium(R) Dual CPU E2160 @ 1.80GHz Linux dbserver4 2.6.24-etchnhalf.1-686-bigmem #1 SMP Mon Jul 21 11:59:12 = UTC 2008 i686 GNU/Linux 4GB RAM --=20 []=B4s, ACV