pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Olivier Andreotti <olivier.andreotti@gmail.com>
To: Chris Mair <list@1006.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
Date: Thu, 18 May 2006 12:42:57 +0200
Message-ID: <d5d40b330605180342o1dc6013fue0b5d678a861c9b5@mail.gmail.com> (raw)
In-Reply-To: <1147947373.7943.35.camel@dell.home.lan>
References: <d5d40b330605180257w2a0cb2dei53d81cbe0d7405e@mail.gmail.com>
	<1147947373.7943.35.camel@dell.home.lan>

2006/5/18, Chris Mair <list@1006.org>:
> 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
= 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



view thread (14+ messages)  latest in thread

Message-ID: <d5d40b330605180342o1dc6013fue0b5d678a861c9b5@mail.gmail.com>
Permalink:  ../d5d40b330605180342o1dc6013fue0b5d678a861c9b5@mail.gmail.com/
Also on:    postgresql.org/message-id/d5d40b330605180342o1dc6013fue0b5d678a861c9b5@mail.gmail.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: olivier.andreotti@gmail.com, list@1006.org
  Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
  In-Reply-To: <d5d40b330605180342o1dc6013fue0b5d678a861c9b5@mail.gmail.com>
  References: <d5d40b330605180257w2a0cb2dei53d81cbe0d7405e@mail.gmail.com> <1147947373.7943.35.camel@dell.home.lan> <d5d40b330605180342o1dc6013fue0b5d678a861c9b5@mail.gmail.com>

* 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