PostgreSQL is the world's most advanced open source relational database system (RDBMS).
As the 4th most used database in the world, it provides the enterprise-level security, functionality, reliability and performance you can only find in advanced DBMSs, but at a fraction of the cost of major proprietary databases. It's feature-rich and standards compliant, highly customisable, and has a large global community of PostgreSQL developers.
You read more about why Fujitsu chose PostgreSQL to underpin its database strategy.
PostgreSQL runs on all major operating systems including Linux, UNIX variants plus Windows, and is fully ACID compliant with full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).
As an enterprise class database, PostgreSQL boasts features such as:
- Multi-Version Concurrency Control (MVCC)
- point in time recovery
- asynchronous replication
- nested transactions (savepoints)
- online/hot backups
- sophisticated query planner/optimiser, and
- write ahead logging for fault tolerance.
It also supports international character sets, multibyte character encodings, Unicode, and is locale-aware for sorting, case-sensitivity, and formatting.
PostgreSQL is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.
You can read more about PostgreSQL at www.postgresql.org/about.