Setup Menus in Admin Panel

Features Matrix

This table outlines which features were added in which version.

Backend

12 11 10 9.6 9.5 9.4
64-bit large objects Yes Yes Yes Yes Yes Yes
Advisory locks Yes Yes Yes Yes Yes Yes
Autovacuum enabled by default Yes Yes Yes Yes Yes Yes
Custom background workers Yes Yes Yes Yes Yes Yes
Disk based FSM Yes Yes Yes Yes Yes Yes
Dollar Quoting Yes Yes Yes Yes Yes Yes
Dynamic Background Workers Yes Yes Yes Yes Yes Yes
EXPLAIN (BUFFERS) support Yes Yes Yes Yes Yes Yes
Full code coverage generation support Yes Yes Yes Yes Yes Yes
Holdable cursors Yes Yes Yes Yes Yes Yes
Integrated autovacuum daemon Yes Yes Yes Yes Yes Yes
Loadable plugin infrastructure for monitoring the planner Yes Yes Yes Yes Yes Yes
Multiple autovacuum workers Yes Yes Yes Yes Yes Yes
Named restore points Yes Yes Yes Yes Yes Yes
Payload support for LISTEN/NOTIFY Yes Yes Yes Yes Yes Yes
Prefix support for text search synonym dictionary Yes Yes Yes Yes Yes Yes
Savepoints Yes Yes Yes Yes Yes Yes
Serializable Snapshot Isolation Yes Yes Yes Yes Yes Yes
SQLDA support for ECPG Yes Yes Yes Yes Yes Yes
SQL-standard information schema Yes Yes Yes Yes Yes Yes
Support for anonymous shared memory Yes Yes Yes Yes Yes Yes
Two Phase commit Yes Yes Yes Yes Yes Yes
Txid functions Yes Yes Yes Yes Yes Yes
UNNEST/array_agg Yes Yes Yes Yes Yes Yes
Updateable cursors Yes Yes Yes Yes Yes Yes
Version aware psql Yes Yes Yes Yes Yes Yes
Visibility map Yes Yes Yes Yes Yes Yes
XML, JSON and YAML output for EXPLAIN Yes Yes Yes Yes Yes Yes

Data Types, Functions, & Operators

12 11 10 9.6 9.5 9.4
Arrays of compound types Yes Yes Yes Yes Yes Yes
Array support Yes Yes Yes Yes Yes Yes
ENUM data type Yes Yes Yes Yes Yes Yes
GUID/UUID data type Yes Yes Yes Yes Yes Yes
Improved set of JSON functions and operators Yes Yes Yes Yes Yes Yes
IS0 8601 interval syntax Yes Yes Yes Yes Yes Yes
JSONB data type Yes Yes Yes Yes Yes Yes
JSONB-modifying operators and functions Yes Yes Yes Yes Yes No
JSON data type Yes Yes Yes Yes Yes Yes
macaddr8 data type Yes Yes Yes No No No
NULLs in Array Yes Yes Yes Yes Yes Yes
Phrase search Yes Yes Yes Yes No No
Range types Yes Yes Yes Yes Yes Yes
smallserial type Yes Yes Yes Yes Yes Yes
Type modifier support Yes Yes Yes Yes Yes Yes
XML data type Yes Yes Yes Yes Yes Yes

Indexing & Constraints

12 11 10 9.6 9.5 9.4
Block-range indexes Yes Yes Yes Yes Yes No
Concurrent GiST indexes Yes Yes Yes Yes Yes Yes
Covering Indexes for B-trees (INCLUDE) Yes Yes No No No No
Covering indexes for GiST (INCLUDE) Yes No No No No No
Crash-safe GiST indexes Yes Yes Yes Yes Yes Yes
Deferrable unique constraints Yes Yes Yes Yes Yes Yes
Exclusion constraints Yes Yes Yes Yes Yes Yes
GIN (Generalized Inverted Index) Indexes Yes Yes Yes Yes Yes Yes
GIN indexes partial match Yes Yes Yes Yes Yes Yes
GIN Index performance and size improvements Yes Yes Yes Yes Yes Yes
GiST (Generalized Search Tree) Indexes Yes Yes Yes Yes Yes Yes
Indexes on expressions Yes Yes Yes Yes Yes Yes
Index-only scans Yes Yes Yes Yes Yes Yes
Index-only scans on GiST Yes Yes Yes Yes Yes No
Index support for IS NULL Yes Yes Yes Yes Yes Yes
In-memory Bitmap Indexes Yes Yes Yes Yes Yes Yes
K-nearest neighbor SP-GiST Support Yes No No No No No
Non-blocking CREATE INDEX Yes Yes Yes Yes Yes Yes
Parallel B-tree index scans Yes Yes Yes No No No
Parallelized CREATE INDEX for B-tree indexes Yes Yes No No No No
Space-Partitioned GiST (SP-GiST) Indexes Yes Yes Yes Yes Yes Yes
SP-GiST indexes for range types Yes Yes Yes Yes Yes Yes
WAL-safe B-Tree Indexes Yes Yes Yes Yes Yes Yes
WAL support for hash indexes Yes Yes Yes No No No

SQL

12 11 10 9.6 9.5 9.4
Common Table Expressions & Recursive Queries Yes Yes Yes Yes Yes Yes
COPY FROM … WHERE Yes No No No No No
GROUPING SETS, CUBE and ROLLUP support Yes Yes Yes Yes Yes No
INSERT … ON CONFLICT DO NOTHING/UPDATE Yes Yes Yes Yes Yes No
INSERT/UPDATE/DELETE RETURNING Yes Yes Yes Yes Yes Yes
LATERAL clause Yes Yes Yes Yes Yes Yes
Multiple input aggregates Yes Yes Yes Yes Yes Yes
Multirow VALUES Yes Yes Yes Yes Yes Yes
ORDER BY NULLS FIRST/LAST Yes Yes Yes Yes Yes Yes
Row-wise comparison Yes Yes Yes Yes Yes Yes
SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE lock modes Yes Yes Yes Yes Yes Yes
SQL/JSON path expressions Yes No No No No No
SQL standard interval handling Yes Yes Yes Yes Yes Yes
TABLE statement Yes Yes Yes Yes Yes Yes
Window functions Yes Yes Yes Yes Yes Yes
WITHIN GROUP clause Yes Yes Yes Yes Yes Yes
WITH ORDINALITY clause Yes Yes Yes Yes Yes Yes
Writable Common Table Expressions Yes Yes Yes Yes Yes Yes

Data Definition Language (DDL)

12 11 10 9.6 9.5 9.4
ALTER object IF EXISTS Yes Yes Yes Yes Yes Yes
ALTER TABLE … ADD UNIQUE/PRIMARY KEY USING INDEX Yes Yes Yes Yes Yes Yes
ALTER TABLE … SET LOGGED / UNLOGGED Yes Yes Yes Yes Yes No
Changing column types (ALTER TABLE .. ALTER COLUMN TYPE) Yes Yes Yes Yes Yes Yes
CREATE ACCESS METHOD Yes No No No No No
CREATE TABLE … (LIKE) with foreign tables, views and composite types Yes Yes Yes Yes Yes Yes
DROP object IF EXISTS Yes Yes Yes Yes Yes Yes
MVCC safe CLUSTER Yes Yes Yes Yes Yes Yes
ON COMMIT clause for CREATE TEMPORARY TABLE Yes Yes Yes Yes Yes Yes
REINDEX CONCURRENTLY Yes No No No No No
Stored Generated Columns Yes No No No No No
Typed tables Yes Yes Yes Yes Yes Yes

Performance

12 11 10 9.6 9.5 9.4
Abbreviated Keys Yes Yes Yes Yes Yes No
Accelerated partition pruning Yes No No No No No
Asynchronous Commit Yes Yes Yes Yes Yes Yes
Automatic plan invalidation Yes Yes Yes Yes Yes Yes
Background Checkpointer Yes Yes Yes Yes Yes Yes
Background Writer Yes Yes Yes Yes Yes Yes
Base backup throttling Yes Yes Yes Yes Yes Yes
CREATE STATISTICS – most-common values (MCV) statistics collection Yes No No No No No
CREATE STATISTICS – multicolumn statistics collection Yes Yes Yes No No No
Cross datatype hashing support Yes Yes Yes Yes Yes Yes
Distributed checkpointing Yes Yes Yes Yes Yes Yes
Foreign keys marked as NOT VALID Yes Yes Yes Yes Yes Yes
Frozen page map Yes Yes Yes Yes No No
Full Text Search Yes Yes Yes Yes Yes Yes
Hashing support for DISTINCT/UNION/INTERSECT/EXCEPT Yes Yes Yes Yes Yes Yes
Hashing support for FULL OUTER JOIN, LEFT OUTER JOIN and RIGHT OUTER JOIN Yes Yes Yes Yes Yes Yes
Hashing support for NUMERIC Yes Yes Yes Yes Yes Yes
Heap Only Tuples (HOT) Yes Yes Yes Yes Yes Yes
Inlined Common Table Expressions (WITH queries) Yes No No No No No
Inlining of SQL-functions Yes Yes Yes Yes Yes Yes
Join removal support Yes Yes Yes Yes Yes Yes
Just-in-Time (JIT) compilation for expression evaluation and tuple deforming Yes Yes No No No No
K-nearest neighbor GiST support Yes Yes Yes Yes Yes Yes
Lazy XID allocation Yes Yes Yes Yes Yes Yes
Multi-core scalability for read-only workloads Yes Yes Yes Yes Yes Yes
Multiple temporary tablespaces Yes Yes Yes Yes Yes Yes
Outer Join reordering Yes Yes Yes Yes Yes Yes
Parallel bitmap heap scans Yes Yes Yes No No No
Parallelized hash joins Yes Yes No No No No
Parallel JOIN, aggregate Yes Yes Yes Yes No No
Parallel merge joins Yes Yes Yes No No No
Parallel query Yes Yes Yes Yes No No
Parallel restore Yes Yes Yes Yes Yes Yes
Parallel seqscan Yes Yes Yes Yes No No
Parallel vacuumdb jobs Yes Yes Yes Yes Yes No
Partial sort capability (top-n sorting) Yes Yes Yes Yes Yes Yes
pg_prewarm Yes Yes Yes Yes Yes Yes
Reduced lock levels for ALTER TABLE commands Yes Yes Yes Yes Yes Yes
SELECT … FOR UPDATE/SHARE NOWAIT Yes Yes Yes Yes Yes Yes
Semi- and Antijoins Yes Yes Yes Yes Yes Yes
Set costs specific to TABLESPACEs Yes Yes Yes Yes Yes Yes
Shared row level locking Yes Yes Yes Yes Yes Yes
SKIP LOCKED clause Yes Yes Yes Yes Yes No
Synchronized sequential scanning Yes Yes Yes Yes Yes Yes
Table partitioning Yes Yes Yes Yes Yes Yes
TABLESAMPLE clause Yes Yes Yes Yes Yes No
Tablespaces Yes Yes Yes Yes Yes Yes
Unlogged tables Yes Yes Yes Yes Yes Yes
WAL Buffer auto-tuning Yes Yes Yes Yes Yes Yes

Partitioning & Inheritance

12 11 10 9.6 9.5 9.4
Declarative table partitioning Yes Yes Yes No No No
Default Partition Yes Yes No No No No
Foreign Key references for partitioned tables Yes No No No No No
Foreign table inheritance Yes Yes Yes Yes Yes No
Partitioning by a hash key Yes Yes No No No No
Support for PRIMARY KEY, FOREIGN KEY, indexes, and triggers on partitioned tables Yes Yes No No No No
UPDATE on a partition key Yes Yes No No No No

Views & Materialized Views

12 11 10 9.6 9.5 9.4
Materialized Views Yes Yes Yes Yes Yes Yes
Materialized views with concurrent refresh Yes Yes Yes Yes Yes Yes
Temporary VIEWs Yes Yes Yes Yes Yes Yes
Updatable views Yes Yes Yes Yes Yes Yes
WITH CHECK clause Yes Yes Yes Yes Yes Yes

Backup, Restore, Data Integrity, & Replication

12 11 10 9.6 9.5 9.4
Cascading streaming replication Yes Yes Yes Yes Yes Yes
Checksum on data pages Yes Yes Yes Yes Yes Yes
Enable/Disable page checksums in an offline cluster Yes No No No No No
Generic WAL facility Yes Yes Yes Yes No No
Hot Standby Yes Yes Yes Yes Yes Yes
Logical Replication Yes Yes Yes No No No
min_wal_size / max_wal_size Yes Yes Yes Yes Yes No
Multiple synchronous standbys Yes Yes Yes Yes No No
Parallel pg_dump Yes Yes Yes Yes Yes Yes
pg_basebackup tool Yes Yes Yes Yes Yes Yes
pg_receivewal (formerly pg_receivexlog) Yes Yes Yes Yes Yes Yes
Point-in-Time Recovery Yes Yes Yes Yes Yes Yes
Quorum commit for synchronous replication Yes Yes Yes No No No
remote_apply mode Yes Yes Yes Yes No No
Replication Slots Yes Yes Yes Yes Yes Yes
Streaming-only cascading replication Yes Yes Yes Yes Yes Yes
Streaming Replication Yes Yes Yes Yes Yes Yes
Synchronous replication Yes Yes Yes Yes Yes Yes
Time-delayed Standbys Yes Yes Yes Yes Yes Yes
Warm Standby Yes Yes Yes Yes Yes Yes

Data Import & Export

12 11 10 9.6 9.5 9.4
COPY from/to STDIN/STDOUT Yes Yes Yes Yes Yes Yes
COPY with arbitrary SELECT Yes Yes Yes Yes Yes Yes
CSV support for COPY Yes Yes Yes Yes Yes Yes

Configuration Management

12 11 10 9.6 9.5 9.4
ALTER SYSTEM Yes Yes Yes Yes Yes Yes
Fractional input for “integer” values Yes No No No No No
Per user/database server configuration settings Yes Yes Yes Yes Yes Yes
pg_config system view Yes Yes Yes Yes No No

Security

12 11 10 9.6 9.5 9.4
Channel binding for SCRAM authentication Yes Yes No No No No
Column level permissions Yes Yes Yes Yes Yes Yes
Default permissions Yes Yes Yes Yes Yes Yes
GRANT/REVOKE ON ALL TABLES/SEQUENCES/FUNCTIONS Yes Yes Yes Yes Yes Yes
GSSAPI client and server-side encryption Yes No No No No No
GSSAPI support Yes Yes Yes Yes Yes Yes
Large object access controls Yes Yes Yes Yes Yes Yes
LDAP server discovery Yes No No No No No
Multifactor authentication via valid client SSL certificate Yes No No No No No
Native LDAP authentication Yes Yes Yes Yes Yes Yes
Native RADIUS authentication Yes Yes Yes Yes Yes Yes
Per user/database connection limits Yes Yes Yes Yes Yes Yes
ROLES Yes Yes Yes Yes Yes Yes
Row-Level Security Yes Yes Yes Yes Yes No
SCRAM-SHA-256 Authentication Yes Yes Yes No No No
Search+bind mode operation for LDAP authentication Yes Yes Yes Yes Yes Yes
security_barrier option on views Yes Yes Yes Yes Yes Yes
Security Service Provider Interface (SSPI) Yes Yes Yes Yes Yes Yes
SSL certificate validation in libpq Yes Yes Yes Yes Yes Yes
SSL client certificate authentication Yes Yes Yes Yes Yes Yes
SSPI authentication via GSSAPI Yes Yes Yes Yes Yes Yes

Foreign Data Wrappers

12 11 10 9.6 9.5 9.4
Foreign data wrappers Yes Yes Yes Yes Yes Yes
Foreign Tables Yes Yes Yes Yes Yes Yes
IMPORT FOREIGN SCHEMA Yes Yes Yes Yes Yes No
postgres_fdw pushdown Yes Yes Yes Yes No No
PostgreSQL Foreign Data Wrapper Yes Yes Yes Yes Yes Yes
Writable Foreign Data Wrappers Yes Yes Yes Yes Yes Yes

Custom Functions, Stored Procedures, & Triggers

12 11 10 9.6 9.5 9.4
ALTER TABLE ENABLE/DISABLE TRIGGER Yes Yes Yes Yes Yes Yes
ALTER TABLE / ENABLE REPLICA TRIGGER/RULE Yes Yes Yes Yes Yes Yes
CALL syntax for executing procedures Yes Yes No No No No
Column level triggers Yes Yes Yes Yes Yes Yes
CREATE PROCEDURE syntax for SQL stored procedures Yes Yes No No No No
Event triggers Yes Yes Yes Yes Yes Yes
FILTER clause for aggregate functions Yes Yes Yes Yes Yes Yes
Function argument names Yes Yes Yes Yes Yes Yes
ORDER BY support within aggregates Yes Yes Yes Yes Yes Yes
Per function GUC settings Yes Yes Yes Yes Yes Yes
Per function statistics Yes Yes Yes Yes Yes Yes
RETURN QUERY EXECUTE Yes Yes Yes Yes Yes Yes
RETURNS TABLE Yes Yes Yes Yes Yes Yes
Statement level triggers Yes Yes Yes Yes Yes Yes
Statement level TRUNCATE triggers Yes Yes Yes Yes Yes Yes
Triggers on views Yes Yes Yes Yes Yes Yes
Variadic functions Yes Yes Yes Yes Yes Yes
WHEN clause for CREATE TRIGGER Yes Yes Yes Yes Yes Yes

Procedural Languages

12 11 10 9.6 9.5 9.4
CASE in pl/pgsql Yes Yes Yes Yes Yes Yes
CONTINUE statement for PL/pgSQL Yes Yes Yes Yes Yes Yes
CREATE TRANSFORM Yes Yes Yes Yes Yes No
DO statement for pl/perl Yes Yes Yes Yes Yes Yes
DO statement for pl/pgsql Yes Yes Yes Yes Yes Yes
EXCEPTION support in PL/pgSQL Yes Yes Yes Yes Yes Yes
EXECUTE USING in PL/pgSQL Yes Yes Yes Yes Yes Yes
FOREACH IN ARRAY in pl/pgsql Yes Yes Yes Yes Yes Yes
IN/OUT/INOUT parameters for pl/pgsql and PL/SQL Yes Yes Yes Yes Yes Yes
Named parameters Yes Yes Yes Yes Yes Yes
Non-superuser language creation Yes Yes Yes Yes Yes Yes
Number of function arguments increased to 100 Yes Yes Yes Yes Yes Yes
pl/pgsql installed by default Yes Yes Yes Yes Yes Yes
Polymorphic functions Yes Yes Yes Yes Yes Yes
Python 3 support for pl/python Yes Yes Yes Yes Yes Yes
Qualified function parameters Yes Yes Yes Yes Yes Yes
RETURN QUERY in pl/pgsql Yes Yes Yes Yes Yes Yes
ROWS and COST specification for functions Yes Yes Yes Yes Yes Yes
Scrollable and updatable cursor support for pl/pgsql Yes Yes Yes Yes Yes Yes
SQLERRM/SQLSTATE for pl/pgsql Yes Yes Yes Yes Yes Yes
Unicode object support in PL/python Yes Yes Yes Yes Yes Yes
User defined exceptions Yes Yes Yes Yes Yes Yes
Validator function for pl/perl Yes Yes Yes Yes Yes Yes

Extensions

12 11 10 9.6 9.5 9.4
CREATE EXTENSION .. CASCADE Yes Yes Yes Yes No No
Extension Installation Yes Yes Yes Yes Yes Yes

Internationalisation

12 11 10 9.6 9.5 9.4
Column-level collation support Yes Yes Yes Yes Yes Yes
Database level Collation Yes Yes Yes Yes Yes Yes
EUC_JIS_2004/ SHIFT_JIS_2004 support Yes Yes Yes Yes Yes Yes
ICU collations Yes Yes Yes No No No
Multibyte encoding support, incl. UTF8 Yes Yes Yes Yes Yes Yes
Multiple language support Yes Yes Yes Yes Yes Yes
Nondeterministic collations Yes No No No No No
Unicode string literals and identifiers Yes Yes Yes Yes Yes Yes
UTF8 support on Windows Yes Yes Yes Yes Yes Yes

Additional Modules (contrib)

12 11 10 9.6 9.5 9.4
contrib/adminpack Yes Yes Yes Yes Yes Yes
contrib/auth_delay Yes Yes Yes Yes Yes Yes
contrib/autoexplain Yes Yes Yes Yes Yes Yes
contrib/btree_gin Yes Yes Yes Yes Yes Yes
contrib/btree_gist Yes Yes Yes Yes Yes Yes
contrib/citext Yes Yes Yes Yes Yes Yes
contrib/dblink Yes Yes Yes Yes Yes Yes
contrib/dblink asyncronous notification support Yes Yes Yes Yes Yes Yes
contrib/file_fdw Yes Yes Yes Yes Yes Yes
contrib/fuzzystrmatch Yes Yes Yes Yes Yes Yes
contrib/hstore Yes Yes Yes Yes Yes Yes
contrib/hstore improvements Yes Yes Yes Yes Yes Yes
contrib/intarray Yes Yes Yes Yes Yes Yes
contrib/isn (ISBN) Yes Yes Yes Yes Yes Yes
contrib/ltree Yes Yes Yes Yes Yes Yes
contrib/pageinspect Yes Yes Yes Yes Yes Yes
contrib/passwordcheck Yes Yes Yes Yes Yes Yes
contrib/pgbench Yes Yes Yes Yes Yes Yes
contrib/pg_buffercache Yes Yes Yes Yes Yes Yes
contrib/pg_freespacemap Yes Yes Yes Yes Yes Yes
contrib/pg_rewind Yes Yes Yes Yes Yes No
contrib/pg_standby Yes Yes Yes Yes Yes Yes
contrib/pg_stat_statements Yes Yes Yes Yes Yes Yes
contrib/pg_stat_statements improvements Yes Yes Yes Yes Yes Yes
contrib/pgstattuple Yes Yes Yes Yes Yes Yes
contrib/pg_trgm Yes Yes Yes Yes Yes Yes
contrib/pg_trgm regular expressions indexing Yes Yes Yes Yes Yes Yes
contrib/pg_upgrade Yes Yes Yes Yes Yes Yes
contrib/pg_xlogdump Yes Yes Yes Yes Yes Yes
contrib/seg Yes Yes Yes Yes Yes Yes
contrib/sepgsql Yes Yes Yes Yes Yes Yes
contrib/sslinfo Yes Yes Yes Yes Yes Yes
contrib/tablefunc Yes Yes Yes Yes Yes Yes
contrib/tcn Yes Yes Yes Yes Yes Yes
contrib/tsearch2 compat wrapper Obsolete Obsolete Obsolete Yes Yes Yes
contrib/unaccent Yes Yes Yes Yes Yes Yes
contrib/uuid-ossp Yes Yes Yes Yes Yes Yes
KNN support for CUBE Yes Yes Yes Yes No No

Network

12 11 10 9.6 9.5 9.4
Full SSL support Yes Yes Yes Yes Yes Yes
IPv6 Support Yes Yes Yes Yes Yes Yes
V3 client protocol Yes Yes Yes Yes Yes Yes

Platforms

12 11 10 9.6 9.5 9.4
Microsoft Visual C++ Support Yes Yes Yes Yes Yes Yes
Native Windows Port Yes Yes Yes Yes Yes Yes
Spinlock support for the SuperH hardware platform Yes Yes Yes Yes Yes Yes
Sun Studio compiler on Linux Yes Yes Yes Yes Yes Yes
Windows x64 support Yes Yes Yes Yes Yes Yes
February 5, 2020

0 responses on "Features Matrix"

Leave a Message

Your email address will not be published. Required fields are marked *

All Rights Reserved 2020 postgresqlcert