X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4A266D1B43C for ; Wed, 26 Nov 2003 22:03:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 86105-02 for ; Wed, 26 Nov 2003 18:03:32 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id 749B2D1B48A for ; Wed, 26 Nov 2003 18:03:24 -0400 (AST) Received: from tokyo.samurai.com (d226-89-59.home.cgocable.net [24.226.89.59]) by bob.samurai.com (Postfix) with ESMTP id 19EDF1F40; Wed, 26 Nov 2003 17:03:31 -0500 (EST) To: LIANHE SHAO Cc: pgsql-performance@postgresql.org Subject: Re: very large db performance question From: Neil Conway In-Reply-To: <4cbacd4cb3c2.4cb3c24cbacd@jhmimail.jhmi.edu> (LIANHE SHAO's message of "Wed, 26 Nov 2003 20:22:01 +0000 (GMT)") References: <4cbacd4cb3c2.4cb3c24cbacd@jhmimail.jhmi.edu> Date: Wed, 26 Nov 2003 17:03:31 -0500 Message-ID: <87u14q6b4c.fsf@mailbox.samurai.com> User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/279 X-Sequence-Number: 4839 LIANHE SHAO writes: > We will have a very large database to store microarray data (may > exceed 80-100G some day). now we have 1G RAM, 2G Hz Pentium 4, 1 > CPU. and enough hard disk. > Could anybody tell me that our hardware is an issue or not? IMHO the size of the DB is less relevant than the query workload. For example, if you're storying 100GB of data but only doing a single index scan on it every 10 seconds, any modern machine with enough HD space should be fine. If you give us an idea of the # of queries you expect per second, the approximate mix of reads and writes, and some idea of how complex the queries are, we might be able to give you some better advice. -Neil