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 C5F2ED1B439 for ; Wed, 26 Nov 2003 20:19:17 +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 72256-04 for ; Wed, 26 Nov 2003 16:18:53 -0400 (AST) Received: from jhuml1.jhmi.edu (jhuml1.jhmi.edu [162.129.234.20]) by svr1.postgresql.org (Postfix) with ESMTP id 11879D1B43E for ; Wed, 26 Nov 2003 16:18:46 -0400 (AST) Received: from jhuml1.jhmi.edu (jhuml1.jhmi.edu [162.129.234.20]) by jhuml1.jhmi.edu (PMDF V6.2-X17 #30839) with SMTP id <0HOZ003VR6ZNE1@jhuml1.jhmi.edu> for pgsql-performance@postgresql.org; Wed, 26 Nov 2003 15:18:52 -0500 (EST) Received: from jhuml1.jhmi.edu ([162.129.234.20]) by jhuml1.jhmi.edu (SAVSMTP 3.1.0.29) with SMTP id M2003112615185228023 for ; Wed, 26 Nov 2003 15:18:52 -0500 Received: from jhmimail.jhmi.edu (jhem2.jhmi.edu [162.129.8.23]) by jhuml1.jhmi.edu (PMDF V6.2-X17 #30839) with ESMTP id <0HOZ008FJ73GMX@jhuml1.jhmi.edu> for pgsql-performance@postgresql.org; Wed, 26 Nov 2003 15:18:52 -0500 (EST) Received: from [162.129.178.60] by jhmimail.jhmi.edu (mshttpd); Wed, 26 Nov 2003 20:22:01 +0000 (GMT) Date: Wed, 26 Nov 2003 20:22:01 +0000 (GMT) From: LIANHE SHAO Subject: very large db performance question To: pgsql-performance@postgresql.org Message-id: <4cbacd4cb3c2.4cb3c24cbacd@jhmimail.jhmi.edu> MIME-version: 1.0 X-Mailer: iPlanet Messenger Express 5.2 HotFix 1.17 (built Jun 23 2003) Content-type: text/plain; charset=us-ascii Content-language: en Content-transfer-encoding: 7bit Content-disposition: inline X-Accept-Language: en X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/277 X-Sequence-Number: 4837 Hello All, 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. I never touched such large database before. I ask several dbas if the hardware is ok, some said it is ok for the query, but I am not so convinced. Because I check the mailing list and learned that it is not unreasonable to take several minutes to do the query. But I want to query to be as fast as possible. Could anybody tell me that our hardware is an issue or not? do we really need better hardware to make real difference? Regards, William