X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DF4A09FA293 for ; Thu, 18 May 2006 07:43:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 04704-10 for ; Thu, 18 May 2006 07:42:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.199]) by postgresql.org (Postfix) with ESMTP id 5566D9F9C18 for ; Thu, 18 May 2006 07:42:59 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id s7so40496wxc for ; Thu, 18 May 2006 03:42:57 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=f5bPYJKtcOaxD9Z6mRb00UMJ1aCuc23vFfnwuuMr5HZQkHINxJu0jFUxnIAXgKb7DnSQJ29dz/U9aRztBSZw83pqAeGUf1Dw3xgQKeCcfFqjNdj4MdpBHwEv+8tQaeZ2kMVU73Z490oB4UJpDcP3FQfuEckuSvDS1XAmEOFcJ3s= Received: by 10.70.23.15 with SMTP id 15mr457503wxw; Thu, 18 May 2006 03:42:57 -0700 (PDT) Received: by 10.70.73.3 with HTTP; Thu, 18 May 2006 03:42:57 -0700 (PDT) Message-ID: Date: Thu, 18 May 2006 12:42:57 +0200 From: "Olivier Andreotti" To: "Chris Mair" Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle Cc: pgsql-performance@postgresql.org In-Reply-To: <1147947373.7943.35.camel@dell.home.lan> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1147947373.7943.35.camel@dell.home.lan> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/380 X-Sequence-Number: 19167 2006/5/18, Chris Mair : > Hello :) > Hello Chris > What version would PostgreSQL 8.1.4 be? > Hum, ok, it is the 8.1.3 version :) > Could you give us some more infos about the box' performance while you > run the PG benchmark? A few minutes output of "vmstat 10" maybe? What > does "top" say? > Here, an extract from the vmstat 3 during the test, you can see that my problem is probably a very high disk usage (write and read). 5 90 92 126792 9240 2429940 0 0 943 10357 3201 2024 18 9 = 0 74 0 21 92 129244 9252 2427268 0 0 799 6389 2228 981 8 3 = 0 89 0 13 92 127236 9272 2428772 0 0 453 8137 2489 1557 5 4 = 0 91 0 51 92 125264 9304 2431296 0 0 725 4999 2206 1763 11 4 = 0 85 0 47 92 127984 9308 2428476 0 0 612 8369 2842 1689 11 4 = 0 85 0 114 92 125572 9324 2430980 0 0 704 8436 2744 1145 11 5 = 0 84 0 29 92 128700 9184 2428020 0 0 701 5948 2748 1688 11 5 = 0 84 49 53 92 127332 9180 2429820 0 0 1053 10221 3107 2156 16 9 = 0 75 0 63 92 124912 9200 2431796 0 0 608 10272 2512 996 10 5 = 0 86 procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu-= --- r b swpd free buff cache si so bi bo in cs us sy id= wa 0 11 92 128344 9224 2428432 0 0 287 9691 2227 685 4 3 = 0 93 0 9 92 124548 9244 2432520 0 0 1168 9859 3186 1967 17 7 = 0 76 0 8 92 128452 9180 2428316 0 0 512 10673 2709 1059 7 3 = 0 89 0 78 92 126820 9192 2429888 0 0 501 7100 2300 1002 6 3 = 0 91 0 80 92 129932 9092 2427128 0 0 860 9103 2850 1724 13 8 = 0 79 2 17 92 125468 9112 2431484 0 0 1311 10268 2890 1540 14 6 = 0 79 0 10 92 127548 9088 2429268 0 0 1048 10404 3244 1810 18 7 = 0 75 0 29 92 126456 9124 2430456 0 0 365 10288 2607 953 6 3 = 0 92 0 25 92 125852 9132 2431012 0 0 172 7168 2202 656 4 3 = 0 93 0 17 92 124968 9188 2431920 0 0 283 4676 1996 708 4 2 = 0 94 0 11 92 129644 9144 2427104 0 0 357 6387 2112 816 5 3 = 0 92 0 16 92 125252 9176 2431804 0 0 1405 6753 2988 2083 21 7 = 0 71 > > How are you using the 3 disks? Did you split pg_xlog and the database > on different disks or not? > Data are on disk 1 et 2. Index on disk 3. Perhaps i'm wrong but fsync =3D off, pg_xlog are running with that ? > > Can you say something about the clients? Do they run over network from > other hosts? What language/bindings do they use? > Client is another server from the same network. Clients are connected with JDBC connector. > When they do inserts, are the inserts bundled or are there > single insert transactions? Are the statements prepared? > > I use prepared statements for all requests. Each transaction is about 5-45 requests. > Bye, Chris. > OA