Runs stored procedures in more than a dozen programming languages, including Java, etc. Permits the database designer to create rules which identify specific operations for a given table or view. Offers the ability to database designers to derive new tables from other tables.
PostgreSQL is an object-relational database management system (ORDBMS) created originally at University of California. Its SQL implementation strongly conforms to the ANSI-SQL 92/99 standards supporting it. It has full support for triggers, views, queries, stored procedures, joins, multiple languages, among others. Some features of this Database include multi version concurrency control (MVCC), point in time recovery, tablespaces, replication (asynchronous), nested transaction, online backups, fault tolerance and many other sophisticated features to provide data integrity.
Some of the allowed maximum values offer big possibilities for huge database systems: unlimited maximum Database size, rows per table and indexes per table, or 32TB maximum for a table's size. The system supports SSL and IPv6 protocols. It also supports many data types, like arrays and XML among many others. Third party contributions are also important for this ORDBMS, because many of the tools to develop, access or use this database exist only because of them. The system also supports GIS (Geographical Information System) data and it can be used for mapping and localization purposes.
The current release includes many fixes reported by its contributors and some new features like full text search integration, support for SQL/XML standard, includes some new data types (enumerated, arrays of composite types, XML, Universal Unique Identifier), it improves logging and statics collections, and much more.
Its installation process is very easy to perform; moreover, some third party utilities and programs are included depending your requests or needs. The Stack Builder utility manages all the installations. Its GUI depends on how would you like to view your data; a nice program to view and manage your databases is pgAdmin III. Its documentation is very complete and detailed; you can find a lot of documentation in its website and included with the program. PostgreSQL works in Linux, UNIX and Windows platforms.
v14.2
- Fix for a low probability scenario of index corruption when a HOT (heap-only tuple) chain changes state during VACUUM. Encountering this issue is unlikely, but if you are concerned, please consider reindexing.
- Fix for using REINDEX CONCURRENTLY on TOAST table indexes to prevent corruption. You can fix any TOAST indexes by reindexing them again.
- The psql \password command now defaults to setting the password for the role defined by CURRENT_USER. Additionally, the role name is now included in the password prompt.
- Build extended statistics for partitioned tables. If you previously added extended statistics to a partitioned table, you should run ANALYZE on those tables. As autovacuum currently does not process partitioned tables, you must periodically run ANALYZE on any partitioned tables to update their statistics.
- Fix crash with ALTER STATISTICS when the statistics object is dropped concurrently.
- Fix crash with multiranges when extracting variable-length data types.
- Several fixes to the query planner that lead to incorrect query results.
- Several fixes for query plan memoization.
- Fix startup of a physical replica to tolerate transaction ID wraparound.
- When using logical replication, avoid duplicate transmission of a partitioned table's data when the publication includes both the child and parent tables.
- Disallow altering data type of a partitioned table's columns when the partitioned table's row type is used as a composite type elsewhere.
- Disallow ALTER TABLE ... DROP NOT NULL for a column that is part of a replica identity index.
- Several fixes for caching that correct logical replication behavior and improve performance.
- Fix memory leak when updating expression indexes.
- Avoid leaking memory during REASSIGN OWNED BY operations that reassign ownership of many objects.
- Fix display of whole-row variables appearing in INSERT ... VALUES rules.
- Fix race condition that could lead to failure to localize error messages that are reported early in multi-threaded use of libpq or ecpglib.
- Fix psql \d command for identifying parent triggers.
- Fix failures on Windows when using the terminal as data source or destination. This affected the psql \copy command and using pg_recvlogical with -f -.
- Fix the pg_dump --inserts and --column-inserts modes to handle tables that contain both generated and dropped columns.
- Fix edge cases in how postgres_fdw handles asynchronous queries. These errors could lead to crashes or incorrect results when attempting to run parallel scans of foreign tables.
Feature-rich relational database known for its high performance and excellent concurrency
