Re: postgresql clustering

Dan,

On 9/29/05 3:23 PM, "Daniel Duvall" <the(dot)liberal(dot)media(at)gmail(dot)com> wrote:

> What about clustered filesystems? At first blush I would think the
> overhead of something like GFS might kill performance. Could one
> potentially achieve a fail-over config using multiple nodes with GFS,
> each having there own instance of PostgreSQL (but only one running at
> any given moment)?

Interestingly - my friend Matt O'Keefe built GFS at UMN, I was one of his
first customers/sponsors of the research in 1998 when I implemented an
8-node shared disk cluster on Alpha Linux using GFS and Fibre Channel.

Again - it depends on what you're doing - if it's OLTP, you will spend too
much time in lock management for disk access and things like Oracle RAC's
CacheFusion becomes critical to reduce the number of times you have to hit
disks. For warehousing/sequential scans, this kind of clustering is
irrelevant.

- Luke