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

From Mitch Pirtle
Subject Re: PostgreSQL clustering VS MySQL clustering
Date
Msg-id 330532b6050120104246597d2a@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL clustering VS MySQL clustering  (Darcy Buskermolen <darcy@wavefire.com>)
Responses Re: PostgreSQL clustering VS MySQL clustering  (Darcy Buskermolen <darcy@wavefire.com>)
Re: PostgreSQL clustering VS MySQL clustering  (Steve Wampler <swampler@noao.edu>)
Re: PostgreSQL clustering VS MySQL clustering  ("Bruno Almeida do Lago" <teolupus@gmail.com>)
List pgsql-performance
On Thu, 20 Jan 2005 09:33:42 -0800, Darcy Buskermolen
<darcy@wavefire.com> wrote:
>
> Another Option to consider would be pgmemcache.  that way you just build the
> farm out of lots of large memory, diskless boxes for keeping the whole
> database in memory in the whole cluster.  More information on it can be found
> at: http://people.freebsd.org/~seanc/pgmemcache/

Which brings up another question: why not just cluster at the hardware
layer? Get an external fiberchannel array, and cluster a bunch of dual
Opterons, all sharing that storage. In that sense you would be getting
one big PostgreSQL 'image' running across all of the servers.

Or is that idea too 90's?  ;-)

-- Mitch

pgsql-performance by date:

Previous
From: "Bruno Almeida do Lago"
Date:
Subject: Re: PostgreSQL clustering VS MySQL clustering
Next
From: Ragnar Hafstað
Date:
Subject: Re: [SQL] OFFSET impact on Performance???