![]() Support for international character sets, e.g.Many extensions that provide additional functionality, including PostGIS.Foreign data wrappers: connect to other databases or streams with a standard SQL interface.Procedural Languages: PL/PGSQL, Perl, Python (and many more).Authentication: GSSAPI, SSPI, LDAP, SCRAM-SHA-256, Certificate, and more.Point-in-time-recovery (PITR), active standbys.Replication: Asynchronous, Synchronous, Logical.Just-in-time (JIT) compilation of expressions.All transaction isolation levels defined in the SQL standard, including Serializable.Parallelization of reading queries and building B-tree indexes.Multi-Version Concurrency Control (MVCC).Transactions, Nested Transactions (via savepoints).Sophisticated query planner/optimizer, index-only scans, multicolumn statistics.Advanced Indexing: GiST, SP-Gist, KNN Gist, GIN, BRIN, Covering indexes, Bloom filters.Indexing: B-tree, Multicolumn, Expressions, Partial. ![]() Customizations: Composite, Custom Types.Document: JSON/JSONB, XML, Key-value (Hstore).Structured: Date/Time, Array, Range, UUID.Primitives: Integer, Numeric, String, Boolean.As of the version 11 release in October 2018, Postgre SQL 64bit version conforms to at least 160 of the 179 mandatory features for SQL:2011 Core conformance, whereas of this writing, no relational database meets full conformance with this standard. Further moves towards conformance can be expected over time. Many of the features required by the SQL standard are supported, though sometimes with slightly differing syntax or function. The app tries to conform with the SQL standard where such conformance does not contradict traditional features or could lead to poor architectural decisions. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database! In addition to being free and open-source, the tool is highly extensible. PostgreSQL 2023 comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation (table sizes can go up to 32 TB). It has native programming interfaces for C/C++, Java. ![]() It also supports storage of binary large objects, including pictures, sounds, or video. It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). PostgreSQL is a powerful object-relational database management system! Download PostgreSQL Offline Installer Setup 64bit for PC! It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, macOS, Solaris, Tru64), and Windows. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. PostgreSQL is a powerful, open-source object-relational database system.
0 Comments
Leave a Reply. |