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 2A2AF8B9B29 for ; Tue, 1 Feb 2005 06:35:46 +0000 (GMT) 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 15470-07 for ; Tue, 1 Feb 2005 06:35:43 +0000 (GMT) Received: from smtp2.libero.it (smtp2.libero.it [193.70.192.52]) by svr1.postgresql.org (Postfix) with ESMTP id 61B6F8B9B27 for ; Tue, 1 Feb 2005 06:35:43 +0000 (GMT) Received: from localhost (172.16.1.80) by smtp2.libero.it (7.0.027-DD01) id 41BDB66300A4BF21; Tue, 1 Feb 2005 07:36:00 +0100 Received: from [62.98.87.210] (62.98.87.210) by smtp0.libero.it (7.0.027-DD01) (authenticated as tdezotti@inwind.it) id 41BF5F48036C9407; Tue, 1 Feb 2005 07:35:41 +0100 Message-ID: <41FF2337.7070809@streppone.it> Date: Tue, 01 Feb 2005 07:35:35 +0100 From: Cosimo Streppone User-Agent: Mozilla Thunderbird 0.9 (X11/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Jim C. Nasby" Cc: Postgresql Performance list Subject: Re: High end server and storage for a PostgreSQL OLTP system References: <41FE97FC.3060106@streppone.it> <20050201045645.GC32356@decibel.org> In-Reply-To: <20050201045645.GC32356@decibel.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at libero.it serv2 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: 200502/9 X-Sequence-Number: 10338 Jim C. Nasby wrote: > On Mon, Jan 31, 2005 at 09:41:32PM +0100, Cosimo wrote: > > >2) The goal is to make the db handle 100 tps (something like > > 100 users). What kind of server and storage should I provide? > > You might look at Opteron's, which theoretically have a higher data > bandwidth. If you're doing anything data intensive, like a sort in > memory, this could make a difference. Would Opteron systems need 64-bit postgresql (and os, gcc, ...) build to have that advantage? > >4) Is it correct to suppose that multiple RAID 1 arrays > > can provide the fastest I/O ? > > I usually reserve one RAID1 array to db data directory, > > one RAID1 array to pg_xlog directory and one RAID1 array > > for os and application needs. > > RAID10 will be faster than RAID1. Sorry Jim, by RAID10 you mean several raid1 arrays mounted on different linux partitions? Or several raid1 arrays that build up a raid0 array? In the latter case, who decides which data goes in which raid1 array? Raid Adapter? > The key factor to a high performance database is a high > performance I/O system. If you look in the archives > you'll find people running postgresql on 30 and 40 > drive arrays. I'll do a search, thank you. -- Cosimo