Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle

2006/5/18, Chris Mair <list(at)1006(dot)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