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 79BD7535F9 for ; Mon, 18 Apr 2005 14:36:18 -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 07163-05 for ; Mon, 18 Apr 2005 17:36:17 +0000 (GMT) Received: from server07.icaen.uiowa.edu (server07.icaen.uiowa.edu [128.255.17.47]) by svr1.postgresql.org (Postfix) with ESMTP id 8124D531DE for ; Mon, 18 Apr 2005 14:36:14 -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 j3IHY5IA028553; (envelope-from ) Mon, 18 Apr 2005 12:36:00 -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 j3IHGEXX011400 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256); (envelope-from ) Mon, 18 Apr 2005 12:16:14 -0500 (CDT) Message-ID: <4263EB5E.8000309@arbash-meinel.com> Date: Mon, 18 Apr 2005 12:16:14 -0500 From: John A Meinel User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alex Turner Cc: Greg Stark , William Yu , pgsql-performance@postgresql.org Subject: Re: How to improve db performance with $7K? References: <425EBA0C.6030804@sfnet.cc> <87pswsku6e.fsf@stark.xeocode.com> <33c6269f0504180817511b27a3@mail.gmail.com> <878y3gks3p.fsf@stark.xeocode.com> <33c6269f05041809566abf91d2@mail.gmail.com> In-Reply-To: <33c6269f05041809566abf91d2@mail.gmail.com> X-Enigmail-Version: 0.91.0.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig6AA3D949B471AC57304693AF" 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/414 X-Sequence-Number: 11811 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig6AA3D949B471AC57304693AF Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Alex Turner wrote: >[snip] > > >>Adding drives will not let you get lower response times than the average seek >>time on your drives*. But it will let you reach that response time more often. >> >> >> >[snip] > >I believe your assertion is fundamentaly flawed. Adding more drives >will not let you reach that response time more often. All drives are >required to fill every request in all RAID levels (except possibly >0+1, but that isn't used for enterprise applicaitons). > Actually 0+1 is the recommended configuration for postgres databases (both for xlog and for the bulk data), because the write speed of RAID5 is quite poor. Hence you base assumption is not correct, and adding drives *does* help. >Most requests >in OLTP require most of the request time to seek, not to read. Only >in single large block data transfers will you get any benefit from >adding more drives, which is atypical in most database applications. >For most database applications, the only way to increase >transactions/sec is to decrease request service time, which is >generaly achieved with better seek times or a better controller card, >or possibly spreading your database accross multiple tablespaces on >seperate paritions. > > This is probably true. However, if you are doing lots of concurrent connections, and things are properly spread across multiple spindles (using RAID0+1, or possibly tablespaces across multiple raids). Then each seek occurs on a separate drive, which allows them to occur at the same time, rather than sequentially. Having 2 processes competing for seeking on the same drive is going to be worse than having them on separate drives. John =:-> --------------enig6AA3D949B471AC57304693AF 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.0 (Cygwin) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCY+teJdeBCYSNAAMRAuzQAKC6qlwljycFzoK4WmZztklbc0DQqACg1qCp lB+Dk7Bd+Beg0Xi40MW3jAM= =kiOJ -----END PGP SIGNATURE----- --------------enig6AA3D949B471AC57304693AF--