|
|
| (24 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| What is Postgresql?
| |
|
| |
|
| PostgreSQL is a powerful, open source object-relational database system based on
| |
|
| |
| POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer
| |
|
| |
| Science Department. It is fully ACID(Atomicity, Consistency, Isolation, Durability) compliant,
| |
|
| |
| has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple
| |
|
| |
| languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN,
| |
|
| |
| CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary
| |
|
| |
| large objects, including pictures, sounds, or video. It has native programming interfaces for C/
| |
|
| |
| C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.
| |
|
| |
| An enterprise class database, PostgreSQL boasts sophisticated features such as Multiversion
| |
|
| |
| concurrency control (MVCC), Point in time recovery, Tablespaces, Savepoints, asynchronous
| |
|
| |
| replication, asynchronous replication, online/hot backups, a sophisticated query planner/
| |
|
| |
| optimizer, and write ahead logging for fault tolerance. It supports international character sets,
| |
|
| |
| multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity,
| |
|
| |
| and formatting. It 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.
| |