X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 508F1D1B4ED for ; Fri, 10 Oct 2003 18:33:58 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 78846-09 for ; Fri, 10 Oct 2003 15:33:09 -0300 (ADT) Received: from jamesr.best.vwh.net (jamesr.best.vwh.net [192.220.76.165]) by svr1.postgresql.org (Postfix) with SMTP id 20B51D1B4FD for ; Fri, 10 Oct 2003 15:33:07 -0300 (ADT) Received: (qmail 29458 invoked by uid 19621); 10 Oct 2003 18:33:05 -0000 Received: from unknown (HELO ?10.0.0.210?) ([65.87.16.98]) (envelope-sender ) by 192.220.76.165 (qmail-ldap-1.03) with SMTP for ; 10 Oct 2003 18:33:05 -0000 Subject: Re: PostgreSQL Scalable ? From: James Rogers To: pgsql-performance@postgresql.org Cc: herve@elma.fr In-Reply-To: <200310101041.09459.josh@agliodbs.com> References: <200310101836.11281.herve@elma.fr> <200310101041.09459.josh@agliodbs.com> Content-Type: text/plain Organization: Message-Id: <1065810785.3099.18.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 10 Oct 2003 11:33:05 -0700 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/359 X-Sequence-Number: 4107 On Fri, 2003-10-10 at 10:41, Josh Berkus wrote: > Herve' > > One other small question ... Does PostgreSQL is scalable ? > > Given that we have several members of our community with 2TB databases, and > one entitiy with a 32TB database, I'd say yes. It depends on what is meant by "scalable". In terms of physical data size, definitely yes. In terms of concurrency, it is also pretty good with only a few caveats (e.g. large SMP systems aren't really exploited to their potential). However, in terms of working set size it is only "fair to middling", which is why I'm looking into those parts right now. So "scalable" really depends on what your load profile looks like. For some load profiles it is extremely scalable and for other load profiles less so, though nothing exhibits truly "poor" scalability that I've found. A lot of scalability is how you set the parameters and design the system if the underlying engine is reasonably competent. For the vast majority of purposes, you'll find that PostgreSQL scales just fine. Cheers, -James Rogers jamesr@best.com