Multiple backends on a single physical database

Multiple backends on a single physical database

Post by Bruce Momji » Sat, 12 Oct 2002 14:19:57






> > > 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.

Quote:> - 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

  +  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

 
 
 

1. Multiple backends on a single physical database

We use V3 over TCP for our NFS mounts from Netapp.  Mount options are
actually: hard,intr,vers=3,proto=tcp,suid,rsize=32768,wsize=32768

Cheers,
CM

--
Chris Miles

http://www.psychofx.com/chris/

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly

2. Oracle ODBC driver for VB

3. Showing index details with \d on psql

4. Dataflex v3.4 - Single file across multiple physical disks

5. server down

6. Database design - multiple physical databases

7. Slow LRC Subroutine

8. Single Database or Multiple Database

9. What are trade-offs for using Single Database vs Multiple Databases

10. Performance Question - 1 Database or Multiple Databases on a single server

11. Multiple Database Vs. Single Database

12. single Database versus multiple database