Re: PostgreSQL clustering VS MySQL clustering

I think maybe a SAN in conjunction with tablespaces might be the answer.
Still need one honking server.

Rick



                      
                      Stephen Frost
                      
                      <sfrost@snowman.net>               To:       Christopher Kings-Lynne
<chriskl@familyhealth.com.au>                      
                      Sent by:                           cc:       Hervé Piedvache <herve@elma.fr>,
pgsql-performance@postgresql.org        
                      pgsql-performance-owner@pos        Subject:  Re: [PERFORM] PostgreSQL clustering VS MySQL
clustering                    
                      tgresql.org
                      

                      

                      
                      01/20/2005 10:08 AM
                      

                      

                      




* Christopher Kings-Lynne (chriskl@familyhealth.com.au) wrote:
> PostgreSQL has replication, but not partitioning (which is what you
want).

It doesn't have multi-server partitioning..  It's got partitioning
within a single server (doesn't it?  I thought it did, I know it was
discussed w/ the guy from Cox Communications and I thought he was using
it :).

> So, your only option is Oracle or another very expensive commercial
> database.

Or partition the data at the application layer.

             Stephen
(See attached file: signature.asc)