X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D1755535D3 for ; Wed, 27 Apr 2005 16:44:01 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39947-08 for ; Wed, 27 Apr 2005 19:43:54 +0000 (GMT) Received: from server07.icaen.uiowa.edu (server07.icaen.uiowa.edu [128.255.17.47]) by svr1.postgresql.org (Postfix) with ESMTP id 6B5055364A for ; Wed, 27 Apr 2005 16:43:51 -0300 (ADT) Received: from server11.icaen.uiowa.edu (server11.icaen.uiowa.edu [128.255.17.51]) by server07.icaen.uiowa.edu (8.13.3/8.12.9) with ESMTP id j3RJhpqm026826; (envelope-from ) Wed, 27 Apr 2005 14:43:51 -0500 (CDT) Received: from [192.168.1.11] (12-215-118-172.client.mchsi.com [12.215.118.172]) (authenticated user=jfmeinel) by server11.icaen.uiowa.edu (8.13.2/smtp-serv-1.7) with ESMTP id j3RJhohQ011315 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256); (envelope-from ) Wed, 27 Apr 2005 14:43:51 -0500 (CDT) Message-ID: <426FEB74.9010201@arbash-meinel.com> Date: Wed, 27 Apr 2005 14:43:48 -0500 From: John A Meinel User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joel Fradkin , pgsql-performance@postgresql.org Subject: Re: Final decision References: <000401c54b59$9d916050$797ba8c0@jfradkin> In-Reply-To: <000401c54b59$9d916050$797ba8c0@jfradkin> X-Enigmail-Version: 0.89.6.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig6F39DA62ED606683D0930E7E" X-Virus-Scanned: ClamAV version 0.83, clamav-milter version 0.83 on clamav.icaen.uiowa.edu X-Virus-Scanned: ClamAV version 0.83, clamav-milter version 0.83 on clamav.icaen.uiowa.edu X-Virus-Status: Clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/745 X-Sequence-Number: 12142 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig6F39DA62ED606683D0930E7E Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Joel Fradkin wrote: ... > > I am guessing our app is like 75% data entry and 25% reporting, but the > reporting is taking the toll SQL wise. > > This was from my insert test with 15 users. > Test type: Dynamic > Simultaneous browser connections: 15 > Warm up time (secs): 0 > Test duration: 00:00:03:13 > Test iterations: 200 > Detailed test results generated: Yes > Response Codes > > Response Code: 403 - The server understood the request, but is refusing to > fulfill it. > Count: 15 > Percent (%): 0.29 > > > Response Code: 302 - The requested resource resides temporarily under a > different URI (Uniform Resource Identifier). > Count: 200 > Percent (%): 3.85 > > > Response Code: 200 - The request completed successfully. > Count: 4,980 > Percent (%): 95.86 > > My select test with 25 users had this > Properties > > Test type: Dynamic > Simultaneous browser connections: 25 > Warm up time (secs): 0 > Test duration: 00:00:06:05 > Test iterations: 200 > Detailed test results generated: Yes > > Summary > > Total number of requests: 187 > Total number of connections: 200 > > Average requests per second: 0.51 > Average time to first byte (msecs): 30,707.42 > Average time to last byte (msecs): 30,707.42 > Average time to last byte per iteration (msecs): 28,711.44 > > Number of unique requests made in test: 1 > Number of unique response codes: 1 Well, having a bandwidth of 392Bps seems *really* low. I mean that is a very old modem speed (3200 baud). I'm wondering if you are doing a lot of aggregating in the web server, and if you couldn't move some of that into the database by using plpgsql functions. That would take some of the load off of your IIS servers, and possibly improve your overall bandwidth. But I do agree, it looks like the select side is where you are hurting. If I understand the numbers correctly, you can do 5k inserts in 3min, but are struggling to do 200 selects in 6min. John =:-> > > Errors Counts > > HTTP: 0 > DNS: 0 > Socket: 26 > > Additional Network Statistics > > Average bandwidth (bytes/sec): 392.08 > > Number of bytes sent (bytes): 64,328 > Number of bytes received (bytes): 78,780 > > Average rate of sent bytes (bytes/sec): 176.24 > Average rate of received bytes (bytes/sec): 215.84 > > Number of connection errors: 0 > Number of send errors: 13 > Number of receive errors: 13 > Number of timeout errors: 0 > > Response Codes > > Response Code: 200 - The request completed successfully. > Count: 187 > Percent (%): 100.00 > > > > > Joel > --------------enig6F39DA62ED606683D0930E7E Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFCb+t0JdeBCYSNAAMRArfoAKDJr1dnPcNbHutb29DV3NUCkfHM8ACgm6+k 5XHEeEbP4XdB0AmTGIPvfpY= =DTO9 -----END PGP SIGNATURE----- --------------enig6F39DA62ED606683D0930E7E--