Re: PostgreSQL clustering VS MySQL clustering - Mailing list pgsql-performance

From Dave Cramer
Subject Re: PostgreSQL clustering VS MySQL clustering
Date
Msg-id 41EFCCF6.1060908@fastcrypt.com
Whole thread Raw
In response to Re: PostgreSQL clustering VS MySQL clustering  (Hervé Piedvache <herve@elma.fr>)
Responses Re: PostgreSQL clustering VS MySQL clustering
Re: PostgreSQL clustering VS MySQL clustering
List pgsql-performance
Google uses something called the google filesystem, look it up in google. It is a distributed file system.

Dave

Hervé Piedvache wrote:
Joshua,

Le Jeudi 20 Janvier 2005 15:44, Joshua D. Drake a écrit : 
Hervé Piedvache wrote:   
My company, which I actually represent, is a fervent user of PostgreSQL.
We used to make all our applications using PostgreSQL for more than 5
years. We usually do classical client/server applications under Linux,
and Web interface (php, perl, C/C++). We used to manage also public web
services with 10/15 millions records and up to 8 millions pages view by
month.     
Depending on your needs either:

Slony: www.slony.info

or

Replicator: www.commandprompt.com

Will both do what you want. Replicator is easier to setup but
Slony is free.   
No ... as I have said ... how I'll manage a database getting a table of may be 
250 000 000 records ? I'll need incredible servers ... to get quick access or 
index reading ... no ?

So what we would like to get is a pool of small servers able to make one 
virtual server ... for that is called a Cluster ... no ?

I know they are not using PostgreSQL ... but how a company like Google do to 
get an incredible database in size and so quick access ?

regards, 

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: [SQL] OFFSET impact on Performance???
Next
From: Hervé Piedvache
Date:
Subject: Re: PostgreSQL clustering VS MySQL clustering