Thread: Clusters and pgsql
Hello, everybody, I'm kinda a newbie in the pgsql world, but I've collected some experience during my short travel through this database system. But there's a point that I've been lacking information about, this is, installing pgsql over a linux cluster, such as the ones managed by Oscar (http://oscar.sourceforge.net), or another cluster administration software, as FreeMosix. If anyone knows, I would linke to be told where can I find information about installations of this kind, and what issues could appear, etc. Which approach is the best for this kind of work?? the multiprocessor over a single node (expensive!!!), or the multinode solution?? Thanks in advance, ---------------------------------------- Luis Hernán Otegui Calle 51 Nº 402, 9º "C" ---------------------------------------- GNU-GPL: "May the source be with you..." ----------------------------------------
On Fri, 2003-08-22 at 12:42, Luis Hernán Otegui wrote: > Hello, everybody, I'm kinda a newbie in the pgsql world, but I've > collected some experience during my short travel through this database > system. > But there's a point that I've been lacking information about, this is, > installing pgsql over a linux cluster, such as the ones managed by Oscar > (http://oscar.sourceforge.net), or another cluster administration > software, as FreeMosix. > If anyone knows, I would linke to be told where can I find information > about installations of this kind, and what issues could appear, etc. > Which approach is the best for this kind of work?? the multiprocessor over > a single node (expensive!!!), or the multinode solution?? Hi, Sorry, but PG isn't designed to have more than 1 computer accessing the files at the same time. Ron -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA YODA: Code! Yes. A programmer's strength flows from code maintainability. But beware of Perl. Terse syntax... more than one way to do it...default variables. The dark side of code maintainability are they. Easily they flow, quick to join you when code you write. If once you start down the dark path, forever will it dominate your destiny, consume you it will.
He ? And excuse me, but what are you on about, Ron ? On Saturday 23 August 2003 17:41, you wrote: > On Fri, 2003-08-22 at 12:42, Luis Hernán Otegui wrote: > > Hello, everybody, I'm kinda a newbie in the pgsql world, but I've > > collected some experience during my short travel through this database > > system. > > But there's a point that I've been lacking information about, this is, > > installing pgsql over a linux cluster, such as the ones managed by Oscar > > (http://oscar.sourceforge.net), or another cluster administration > > software, as FreeMosix. > > If anyone knows, I would linke to be told where can I find information > > about installations of this kind, and what issues could appear, etc. > > Which approach is the best for this kind of work?? the multiprocessor > > over a single node (expensive!!!), or the multinode solution?? > > Hi, > > Sorry, but PG isn't designed to have more than 1 computer accessing > the files at the same time. > > Ron
On Sat, 23 Aug 2003, Aarni [iso-8859-1] Ruuhim�ki wrote: > He ? And excuse me, but what are you on about, Ron ? Many machines may access the server through the communications protocol, but only one should be directly accessing the on-disk data files. > > On Fri, 2003-08-22 at 12:42, Luis Hern�n Otegui wrote: > > > > Sorry, but PG isn't designed to have more than 1 computer accessing > > the files at the same time.
In article <20030823095009.S26407-100000@megazone.bigpanda.com>,
Stephan Szabo <sszabo@megazone.bigpanda.com> wrote:
>
>On Sat, 23 Aug 2003, Aarni [iso-8859-1] Ruuhim�ki wrote:
>
>> He ? And excuse me, but what are you on about, Ron ?
>
>Many machines may access the server through the communications protocol,
>but only one should be directly accessing the on-disk data files.
I don't know about Oscar, but with FreeMosix, the cluster appears to the
application to be more or less like one multi-cpu machine. The kernel
patches hide everything from the application.
However, last I heard, FreeMosix won't do SysV shared memory, which Postgres
requires.
Also, FreeMosix works better on CPU intensive applications; I'd think the
disk usage Postgres requires would negate any speed up you'd get by
migrating the process to a different machine.
mrc
--
Mike Castle dalgoda@ix.netcom.com www.netcom.com/~dalgoda/
We are all of us living in the shadow of Manhattan. -- Watchmen
fatal ("You are in a maze of twisty compiler features, all different"); -- gcc