PostgreSQL

PostgreSQL is an advanced database server having more than 25 years of development history. PostgreSQL was born from the same research as Oracle and DB2. It is available for a wide range of platforms, and is used on the smallest embedded systems to massive multi-terabyte systems. PostgreSQL has earned an excellent reputation due to its innovative features, integrity, security and reliability. The product contains comparable enterprise-class features such as full Atomicity, Consistency, Isolation, Durability (ACID) compliance for outstanding transaction reliability and Multi-Version Concurrency Control (MVCC) for supporting high concurrent loads.

One of the clearest benefits of PostgreSQL is that it is open source, meaning that you have a license to install, use, and distribute PostgreSQL without paying royalties. In many cases, the data stored can be tremendously important and the availability of services that rely on it may be critical.

On top of that, PostgreSQL is well-known as a database that stays up for long periods, and requires little or no maintenance in many cases. Overall, PostgreSQL provides a very low total cost of ownership.

Below are listed the main features of PostgreSQL:

The features from the latest 10 release are listed in more detail here.

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. Some general PostgreSQL limits are included in the table below.

 

Limit Value
Maximum Database Size Unlimited
Maximum Table Size 32 TB
Maximum Row Size 1.6 TB
Maximum Field Size 1 GB
Maximum Rows per Table Unlimited
Maximum Columns per Table 250 – 1600 depending on column types
Maximum Indexes per Table Unlimited

 

PostgreSQL was awarded the Linux New Media Award for Best Database System and is a five time winner of The Linux Journal Editors’ Choice Award for best DBMS.

License

PostgreSQL is released under the PostgreSQL License, a liberal Open Source license, similar to the BSD or MIT licenses.

 

PostgreSQL is bringing to your organization the intelligent technological independence