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

 · 

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