2006/5/18, Chris Mair <list@xxxxxxxx>:
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
