From: James Rogers <jamesr@best.com>
To: pgsql-performance@postgresql.org
Cc: herve@elma.fr
Subject: Re: PostgreSQL Scalable ?
Date: 10 Oct 2003 11:33:05 -0700
Message-ID: <1065810785.3099.18.camel@localhost.localdomain> (raw)
In-Reply-To: <200310101041.09459.josh@agliodbs.com>
References: <200310101836.11281.herve@elma.fr>
<200310101041.09459.josh@agliodbs.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jamesr@best.com, herve@elma.fr
Subject: Re: PostgreSQL Scalable ?
In-Reply-To: <1065810785.3099.18.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox