Re: [ADMIN] Multiple backends on a single physical database

Anuradha Ratnaweera wrote:

On Thu, Oct 10, 2002 at 10:09:55AM -0400, Bruce Momjian wrote:

Vincent Janelle wrote:

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?

No, not really. The multi-process model seems to work fine, and though
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.

- Add more fault tolerence by better replication (yes. I have already
looked at current replication efforts)?

Not really, just the replication projects and the multi-master
pgreplication at gborg.postgresql.org.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073