> > > No. Only one postmaster can access the PGDATA dir at one time.
> > > Attempting to run multiple copies will result in data corruption.
> > We also don't recommend NFS directories because the NFS file behavior is
> > not 100% the same as a local file system.
> Obviously fsync(), WAL and NFS is not a good combination ;)
> As we are looking for possibilities to contribute to the postgresql
> code, I have couple of more questions.
> Is there any plans to,
> - Make postmaster a multithreaded application?
we can imagine cases where having more than one thread for a session
would help (like in sorting) we are not sure it is worth the added
complexity. We already have other areas of easier optimization left to
improve.
Not really, just the replication projects and the multi-masterQuote:> - Add more fault tolerence by better replication (yes. I have already
> looked at current replication efforts)?
pgreplication at gborg.postgresql.org.
--
Bruce Momjian | http://candle.pha.pa.us
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command