Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4A00A64FEAF for ; Thu, 16 Oct 2008 11:08:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39120-08 for ; Thu, 16 Oct 2008 11:08:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp-out114.alice.it (smtp-out114.alice.it [85.37.17.114]) by postgresql.org (Postfix) with ESMTP id 00E1664FC00 for ; Thu, 16 Oct 2008 11:08:03 -0300 (ADT) Received: from FBCMMO03.fbc.local ([192.168.68.197]) by smtp-out114.alice.it with Microsoft SMTPSVC(6.0.3790.1830); Thu, 16 Oct 2008 16:08:03 +0200 Received: from FBCMCL01B02.fbc.local ([192.168.69.83]) by FBCMMO03.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Thu, 16 Oct 2008 16:08:00 +0200 Received: from kerberos.webthatworks.it ([82.48.124.156]) by FBCMCL01B02.fbc.local with Microsoft SMTPSVC(6.0.3790.1830); Thu, 16 Oct 2008 16:08:02 +0200 Received: from dawn.webthatworks.it (dawn.webthatworks.it [192.168.1.12]) by kerberos.webthatworks.it (Postfix) with ESMTP id 285E2E6A96 for ; Thu, 16 Oct 2008 16:07:58 +0200 (CEST) Received: from dawn.webthatworks.it (localhost [127.0.0.1]) by dawn.webthatworks.it (Postfix) with ESMTP id EE5AF3DA95 for ; Thu, 16 Oct 2008 16:07:56 +0200 (CEST) Date: Thu, 16 Oct 2008 16:07:56 +0200 From: Ivan Sergio Borgonovo To: pgsql-general@postgresql.org Subject: further tests with 8.3 was: Re: Drupal and PostgreSQL - performance issues? Message-ID: <20081016160756.79d6a771@dawn.webthatworks.it> In-Reply-To: <20081014184456.0b920620@dawn.webthatworks.it> References: <2434A118-CEFA-43A9-BA88-006EC1F80326@hoegh.org> <200810122214.53558.uwe@oss4u.com> <20081013090228.248a665f@dawn.webthatworks.it> <20081014114011.0ebe495a@dawn.webthatworks.it> <20081014184456.0b920620@dawn.webthatworks.it> Organization: http://www.webthatworks.it X-Mailer: Claws Mail 3.5.0 (GTK+ 2.12.11; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 16 Oct 2008 14:08:02.0914 (UTC) FILETIME=[9A6D0420:01C92F98] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/677 X-Sequence-Number: 138926 On Tue, 14 Oct 2008 18:44:56 +0200 Ivan Sergio Borgonovo 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