Re: PostgreSQL Scalable ?

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