X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CFD663A45AA for ; Thu, 20 Jan 2005 15:22:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13692-07 for ; Thu, 20 Jan 2005 15:22:09 +0000 (GMT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id 1D2D63A47E8 for ; Thu, 20 Jan 2005 15:22:12 +0000 (GMT) Received: (qmail 26510 invoked from network); 20 Jan 2005 15:21:37 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.36?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 20 Jan 2005 15:21:37 -0000 Message-ID: <41EFCCF6.1060908@fastcrypt.com> Date: Thu, 20 Jan 2005 10:23:34 -0500 From: Dave Cramer Reply-To: pg@fastcrypt.com Organization: Postgres International User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: =?ISO-8859-15?Q?Herv=E9_Piedvache?= Cc: "Joshua D. Drake" , pgsql-performance@postgresql.org Subject: Re: PostgreSQL clustering VS MySQL clustering References: <200501201503.31241.herve@elma.fr> <41EFC3C0.6080903@commandprompt.com> <200501201600.47583.herve@elma.fr> In-Reply-To: <200501201600.47583.herve@elma.fr> Content-Type: multipart/alternative; boundary="------------000002000804000801020902" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.307 tagged_above=0 required=5 tests=AWL, HTML_30_40, HTML_MESSAGE, HTML_TITLE_EMPTY, INFO_TLD X-Spam-Level: X-Archive-Number: 200501/297 X-Sequence-Number: 9987 This is a multi-part message in MIME format. --------------000002000804000801020902 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 8bit 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 --------------000002000804000801020902 Content-Type: text/html; charset=ISO-8859-15 Content-Transfer-Encoding: 8bit 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
--------------000002000804000801020902--