Postgres Pro
Downloads
Home   >   mailing lists

Postgres Equivalent of Oracle Optimal Flexible Architecture (OOFA) or MySQL Optimal Configuration Architecture (MOCA) - Mailing list pgsql-admin

From Mark Lehmann
Subject Postgres Equivalent of Oracle Optimal Flexible Architecture (OOFA) or MySQL Optimal Configuration Architecture (MOCA)
Date
Msg-id 8fa2a6330906081346s5a3f300at2352ee69a5854c23@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
I'm looking for some Postgres Standards similar to the:

- Oracle Optimal Flexible Architecture (OOFA) / http://www.dba-oracle.com/t_ofa_optimal_flexible_architecture.htm
- MySQL Optimal Configuration Architecture (MOCA) / http://mysql-dba-journey.blogspot.com/2007/12/mysql-architecture-using-moca.html

Also, is there a PostgreSQL standard for diagramming physical database storage architecture.  I'm referring to things like naming conventions of filesystems, separation of filesystem purposes, and ideal configuration when using RAID 10, RAID 5, RAID 6 etc.

I expect that nothing exists exactly matching that for which I am looking.  Anything close or even not so close would be helpful.  I'm willing to create one for PostgreSQL for review by the community if it would be helpful.

--
Mark Lehmann
512 689-7705 M

pgsql-admin by date:

Previous
From: Roland Hughes
Date:
Subject: Add pre-existing tablespace to new installation
Next
From: Tino Schwarze
Date:
Subject: Re: Add pre-existing tablespace to new installation