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 D2F353A6037 for ; Fri, 28 Jan 2005 18:10:29 +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 77163-06 for ; Fri, 28 Jan 2005 18:10:26 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 58A583A6065 for ; Fri, 28 Jan 2005 18:10:27 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j0SIAPMu074447 for ; Fri, 28 Jan 2005 18:10:25 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j0SHo7Ud070693 for pgsql-admin@postgresql.org; Fri, 28 Jan 2005 17:50:07 GMT (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: Database Scalability Date: Fri, 28 Jan 2005 12:05:11 -0500 Organization: cbbrowne Computing Inc Lines: 32 Message-ID: References: <20050128045400.62180.qmail@web207.biz.mail.re2.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Corporate Culture, linux) Cancel-Lock: sha1:EU9IkZE7d2YmKVluFJ0nvn/kaTY= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200501/287 X-Sequence-Number: 16146 In an attempt to throw the authorities off his trail, jagan@syringacommunications.com ("M.V. Jaga Mohan") transmitted: > 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. That depends mainly on how much disk space you have. If you haven't got much disk, you won't be able to store many records. If you have 8TB of free space, you should be able to store rather a lot, depending on how large they might be. > and what will be the data retreival speed when multiple clients > access the database. Is there any software or mechanism to find out > this ? Retrieval speed will depend on various things, including: - How fast your disk subsystem is; - How much data you can cache in memory; - How effectively you have tuned PostgreSQL's use of caches - How useful the set of indices are on your tables - How efficient the queries you have written for data retrieval are at utilizing all of the above. You would likely find that 7.4 releases would be quite a bit faster and more efficient than the 7.3 series, due to various improvements to the query planner, and possibly that the new version 8.0 is even faster still. I find it curious that you want to use so old a version of PostgreSQL. -- wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','gmail.com'). http://cbbrowne.com/info/linuxxian.html "Did you ever walk in a room and forget why you walked in? I think that's how dogs spend their lives." -- Sue Murphy