On Tue, 14 Oct 2008 18:44:56 +0200 Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> wrote: > BTW I hope someone may find good use of this: > 2xXeon HT CPU 3.20GHz (not dual core), 4Gb RAM, RAID 5 SCSI > * absolutely not tuned Apache > * absolutely not tuned Drupal with little content, some blocks and > some google adds > (just CSS aggregation and caching enabled) > * lightly tuned PostgreSQL 8.1 > shared_buffers = 3500 > work_mem = 32768 > checkpoint_segments = 10 > effective_cache_size = 15000 > random_page_cost = 3 > default_statistics_target = 30 comparison between 8.1 and 8.3, similar tuning, (D5) 8.3 uses sockets, can't easily go back to check if 8.1 used tcp/ip. BTW I had to hack D5 core to use sockets. (commented out the host line in include/database.pgsql.inc). > siege -H "Cookie: drupalsessid" -c1 "localhost/d1" > -b -t30s > -c 1 > Transactions: 485 hits > Availability: 100.00 % > Elapsed time: 29.95 secs > Data transferred: 5.33 MB > Response time: 0.06 secs > Transaction rate: 16.19 trans/sec > Throughput: 0.18 MB/sec > Concurrency: 1.00 > Successful transactions: 485 > Failed transactions: 0 > Longest transaction: 0.13 > Shortest transaction: 0.06 Transactions: 842 hits Availability: 100.00 % Elapsed time: 29.87 secs Data transferred: 9.26 MB Response time: 0.04 secs Transaction rate: 28.19 trans/sec Throughput: 0.31 MB/sec Concurrency: 1.00 Successful transactions: 842 Failed transactions: 0 Longest transaction: 0.09 Shortest transaction: 0.03 > -c 5 > Transactions: 1017 hits > Availability: 100.00 % > Elapsed time: 29.61 secs > Data transferred: 11.29 MB > Response time: 0.15 secs > Transaction rate: 34.35 trans/sec > Throughput: 0.38 MB/sec > Concurrency: 4.98 > Successful transactions: 1017 > Failed transactions: 0 > Longest transaction: 0.24 > Shortest transaction: 0.08 Transactions: 1674 hits Availability: 100.00 % Elapsed time: 29.93 secs Data transferred: 18.80 MB Response time: 0.09 secs Transaction rate: 55.93 trans/sec Throughput: 0.63 MB/sec Concurrency: 4.98 Successful transactions: 1674 Failed transactions: 0 Longest transaction: 0.20 Shortest transaction: 0.05 > -c 20 > Transactions: 999 hits > Availability: 100.00 % > Elapsed time: 30.11 secs > Data transferred: 11.08 MB > Response time: 0.60 secs > Transaction rate: 33.18 trans/sec > Throughput: 0.37 MB/sec > Concurrency: 19.75 > Successful transactions: 999 > Failed transactions: 0 > Longest transaction: 1.21 > Shortest transaction: 0.10 Transactions: 1677 hits Availability: 100.00 % Elapsed time: 29.68 secs Data transferred: 18.86 MB Response time: 0.35 secs Transaction rate: 56.50 trans/sec Throughput: 0.64 MB/sec Concurrency: 19.89 Successful transactions: 1677 Failed transactions: 0 Longest transaction: 0.74 Shortest transaction: 0.09 > -c 100 > Transactions: 1085 hits > Availability: 100.00 % > Elapsed time: 29.97 secs > Data transferred: 9.61 MB > Response time: 2.54 secs > Transaction rate: 36.20 trans/sec > Throughput: 0.32 MB/sec > Concurrency: 91.97 > Successful transactions: 911 > Failed transactions: 0 > Longest transaction: 12.41 > Shortest transaction: 0.07 Transactions: 1651 hits Availability: 100.00 % Elapsed time: 29.78 secs Data transferred: 17.41 MB Response time: 1.73 secs Transaction rate: 55.44 trans/sec Throughput: 0.58 MB/sec Concurrency: 95.68 Successful transactions: 1563 Failed transactions: 0 Longest transaction: 3.97 Shortest transaction: 0.06 > -c 200 > Transactions: 1116 hits > Availability: 100.00 % > Elapsed time: 30.02 secs > Data transferred: 9.10 MB > Response time: 4.85 secs > Transaction rate: 37.18 trans/sec > Throughput: 0.30 MB/sec > Concurrency: 180.43 > Successful transactions: 852 > Failed transactions: 0 > Longest transaction: 15.85 > Shortest transaction: 0.25 Transactions: 1689 hits Availability: 100.00 % Elapsed time: 30.00 secs Data transferred: 16.52 MB Response time: 3.30 secs Transaction rate: 56.30 trans/sec Throughput: 0.55 MB/sec Concurrency: 185.76 Successful transactions: 1483 Failed transactions: 0 Longest transaction: 8.37 Shortest transaction: 0.08 Sorry to introduce so many factors to make a reasonable comparison. Now I'm having problems with 8.3 and ssl connections from outside... I wonder if pg is using ssl even on sockets. -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
