Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle - Mailing list pgsql-performance

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