further tests with 8.3 was: Re: Drupal and PostgreSQL - performance issues?

On Tue, 14 Oct 2008 18:44:56 +0200
Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> 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