further tests with 8.3 was: Re: Drupal and PostgreSQL - performance issues? - Mailing list pgsql-general

On Tue, 14 Oct 2008 18:44:56 +0200
Ivan Sergio Borgonovo <mail@webthatworks.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