X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DD44A3A61BA for ; Fri, 28 Jan 2005 04:54:12 +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 99230-02 for ; Fri, 28 Jan 2005 04:54:03 +0000 (GMT) Received: from web207.biz.mail.re2.yahoo.com (web207.biz.mail.re2.yahoo.com [68.142.224.169]) by svr1.postgresql.org (Postfix) with SMTP id 040F63A61A9 for ; Fri, 28 Jan 2005 04:54:02 +0000 (GMT) Message-ID: <20050128045400.62180.qmail@web207.biz.mail.re2.yahoo.com> Received: from [61.11.48.29] by web207.biz.mail.re2.yahoo.com via HTTP; Thu, 27 Jan 2005 20:54:00 PST Date: Thu, 27 Jan 2005 20:54:00 -0800 (PST) From: "M.V. Jaga Mohan" Subject: Database Scalability To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.026 tagged_above=0 required=5 tests=RCVD_IN_NJABL_PROXY X-Spam-Level: * X-Archive-Number: 200501/283 X-Sequence-Number: 16142 HI All, I am using PgSQL 7.3 for my Application. My problem how can I scale my database ? I mean how many records I can have in my database. and what will be the data retreival speed when multiple clients access the database. Is there any software or mechanism to find out this ? Any help in this regard is highly appreciated. thanks Jagan =====