안녕하세요~
오늘은 Open Source의 양대 산맥(?)인 PostgreSQL vs MySQL의
주요 기능에 대해 한 눈에 비교해보겠습니다.
| PostgreSQL | MySQL | |
| Website | www.postgresql.org | www.mysql.com |
| License | PostgreSQL Licence | GPL |
| Proprietary | ||
| Design | ||
| Database model | Object-Relational Database Management System | Relational database system |
| Data storage | File System | File System |
| Volatile memory | ||
| Embeddable | No | Yes |
| Features | ||
| Query language | SQL | SQL |
| Unicode | Yes | Yes |
| Compression | Yes | Yes |
| Integrity | ||
| Integrity model | ACID | ACID |
| Atomicity | Yes | Yes |
| Consistency | Yes | Yes |
| Isolation | Yes | Yes |
| Durability (data storage) | Yes | Yes |
| Transactions | Yes | Yes |
| Referential integrity | Yes | Yes |
| Locking model | MVCC | Lock Model |
| 동시 테이블 접근시 정합성을 맞추는 방식 | Read Lock / Write Lock mode | |
| Indexing | ||
| Secondary Indexes | Yes | Yes |
| Composite keys | Yes | Yes |
| Full text search | Yes | Yes |
| Geospatial Indexes | Yes | Yes |
| Partial Index | Yes | No |
| Function Based Index | Yes | No |
| Graph support | Yes | No |
| Distribution (분산) | ||
| Horizontal scalable | No | No |
| Replication | Yes | Yes |
| Replication mode | Master-Slave Replication | Master-Slave Replication |
| Sharding | Yes | Yes |
| Shared nothing architecture | Yes | Yes |
| Restrictions (제한) | ||
| Value size max. | 1 GB | 10 B |
| System requirements | ||
| Operating system | *NIX | *NIX |
| Linux | Linux | |
| Mac OS X | Windows | |
| Windows | Mac OS X | |
| iOS | FreeBSD | |
| FreeBSD | ||
| Native driver | PHP | PHP |
| Perl | C# | |
| Python | ruby | |
| Ruby | Ruby | |
| C# | Python | |
| C++ | C# | |
| C# | C | |
| ruby | ||
| Erlang | ||
| Tcl | ||
| Dart | ||
| Memory minimum | 32 MB | 11 MB |
| Architecture | ||
| Programming language | C# | C++ |
| C# | ||
| More | ||
| Multi-user system | Yes | Yes |
| Extension/Plug-in | Yes | Yes |
| Free to use | Yes | Conditional |
| Database Connection Pooling | Yes | Yes |
| Community Driven | Good | Good |
| Web interface | Yes | Yes |
| Cloud platform support | Amazon EC2 | Amazon EC2 |
| Heroku | ||
| OpenShift | ||
| Online backup | Yes | Yes |
| Log | Yes | Yes |
| Free for commercial use | Yes | Yes |
| Sorts | Yes | Yes |
| Open Source | Yes | Yes |
| Triggers | Yes | Yes |
| Stored Procedure | Yes | Yes |
원문 : http://vschart.com/compare/postgresql/vs/mysql
by. 진준호 (2014.07.30)
'2. DBMS이야기 > 01. PostgreSQL' 카테고리의 다른 글
| [Admin] 3.Server Configuration : Parameter 종류(Write Ahead Log) (0) | 2014.08.01 |
|---|---|
| Postgres SQL과 Oracle의 Engine 비교 (0) | 2014.07.31 |
| PostgreSQL Privileges Test 1 (0) | 2014.07.28 |
| PG_RESTORE (0) | 2014.07.26 |
| PHP에서 PostgreSQL 사용하기 (0) | 2014.07.25 |