pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Josh Berkus <josh@agliodbs.com>
To: Hervé Piedvache <herve@elma.fr>
To: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: PostgreSQL Scalable ?
Date: Fri, 10 Oct 2003 10:41:09 -0700
Message-ID: <200310101041.09459.josh@agliodbs.com> (raw )
In-Reply-To: <200310101836.11281.herve@elma.fr >
References: <200310101836.11281.herve@elma.fr >
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.
> I mean ... is it possible to have two servers, one rack of disks connected
> to the 2 servers to get access in same time to the same database ?
Not at this time, no.
> Other point is there any possibilties to make servers clusters with
> PostgreSQL ? If no why ? If yes how ? ;o)
Only via replication or creative use of DBLink. Nobody has yet offered to
build us database server clustering, which would be very nice to have, but
would require a substantial investment from a corporate sponsor.
> To be clear I would like to make a system with PostgreSQL able to answer
> about 70 000 000 requests by day (Internet services) ... I'm not sure about
> the server configuration I have to make.
That sounds doable on proper hardware with good tuning. Might I suggest
that you consider hiring a consultant and start from there? I believe that
Afilias Limited (www.afilias.info) has the requisite experience in Europe.
--
Josh Berkus
Aglio Database Solutions
San Francisco
view thread (4+ messages) latest in thread
Message-ID: <200310101041.09459.josh@agliodbs.com>
Permalink: ../200310101041.09459.josh@agliodbs.com/
Also on: postgresql.org/message-id/200310101041.09459.josh@agliodbs.com
copy link · copy postgr.es
reply 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: josh@agliodbs.com, herve@elma.fr
Subject: Re: PostgreSQL Scalable ?
In-Reply-To: <200310101041.09459.josh@agliodbs.com>
* 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