Skip site navigation (1) Skip section navigation (2)

Feature Matrix

This table outlines which features were added in which version. To get more information about a feature, click the link or hover the mouse pointer over the text.

Groups

Backend 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3
64-bit large objects No No No No No No No No Yes
Advisory locks No No Yes Yes Yes Yes Yes Yes Yes
ALTER object IF EXISTS No No No No No No No Yes Yes
ALTER TABLE ... ADD UNIQUE/PRIMARY KEY USING INDEX No No No No No No Yes Yes Yes
Autovacuum enabled by default No No No Yes Yes Yes Yes Yes Yes
Cascading streaming replication No No No No No No No Yes Yes
Changing column types (ALTER TABLE .. ALTER COLUMN TYPE) Yes Yes Yes Yes Yes Yes Yes Yes Yes
Checksum on data pages No No No No No No No No Yes
Column level permissions No No No No Yes Yes Yes Yes Yes
Common Table Expressions (WITH RECURSIVE) No No No No Yes Yes Yes Yes Yes
Concurrent GiST indexes No Yes Yes Yes Yes Yes Yes Yes Yes
COPY from/to STDIN/STDOUT No No No No No No No No Yes
COPY with arbitrary SELECT No No Yes Yes Yes Yes Yes Yes Yes
Crash-safe GiST indexes No Yes Yes Yes Yes Yes Yes Yes Yes
CREATE TABLE ... (LIKE) with foreign tables, views and composite types No No No No No No No Yes Yes
CSV support for COPY Yes Yes Yes Yes Yes Yes Yes Yes Yes
Custom background workers No No No No No No No No Yes
Default permissions No No No No No Yes Yes Yes Yes
Deferrable unique constraints No No No No No Yes Yes Yes Yes
Disk based FSM No No No No Yes Yes Yes Yes Yes
Dollar Quoting Yes Yes Yes Yes Yes Yes Yes Yes Yes
DROP object IF EXISTS No No Yes Yes Yes Yes Yes Yes Yes
Exclusion constraints No No No No No Yes Yes Yes Yes
EXPLAIN (BUFFERS) support No No No No No Yes Yes Yes Yes
Extension package installation No No No No No No Yes Yes Yes
Foreign data wrappers No No No No No No Yes Yes Yes
Foreign Tables No No No No No No Yes Yes Yes
Full code coverage generation support No No No No No Yes Yes Yes Yes
GRANT/REVOKE ON ALL TABLES/SEQUENCES/FUNCTIONS No No No No No Yes Yes Yes Yes
Holdable cursors Yes Yes Yes Yes Yes Yes Yes Yes Yes
Hot Standby No No No No No Yes Yes Yes Yes
Improved set of JSON functions and operators No No No No No No No No Yes
INSERT/UPDATE/DELETE RETURNING No No Yes Yes Yes Yes Yes Yes Yes
Integrated autovacuum daemon No Yes Yes Yes Yes Yes Yes Yes Yes
Join removal support No No No No No Yes Yes Yes Yes
LATERAL clause No No No No No No No No Yes
Loadable plugin infrastructure for monitoring the planner No No No Yes Yes Yes Yes Yes Yes
Materialized views No No No No No No No No Yes
Multiple autovacuum workers No No No Yes Yes Yes Yes Yes Yes
Multiple input aggregates No No Yes Yes Yes Yes Yes Yes Yes
Multirow VALUES No No Yes Yes Yes Yes Yes Yes Yes
MVCC safe CLUSTER No No No Yes Yes Yes Yes Yes Yes
Named restore points No No No No No No Yes Yes Yes
ON COMMIT clause for CREATE TEMPORARY TABLE Yes Yes Yes Yes Yes Yes Yes Yes Yes
ORDER BY NULLS FIRST/LAST No No No Yes Yes Yes Yes Yes Yes
Parallel pg_dump No No No No No No No No Yes
Payload support for LISTEN/NOTIFY No No No No No Yes Yes Yes Yes
Per tablespace support for GUCs No No No No No Yes Yes Yes Yes
Per user/database server configuration settings No No No No No Yes Yes Yes Yes
Pg_basebackup tool No No No No No No Yes Yes Yes
pg_receivexlog tool No No No No No No No Yes Yes
Point-in-Time Recovery Yes Yes Yes Yes Yes Yes Yes Yes Yes
Prefix support for text search synonym dictionary No No No No No Yes Yes Yes Yes
Row-wise comparison No No Yes Yes Yes Yes Yes Yes Yes
Savepoints Yes Yes Yes Yes Yes Yes Yes Yes Yes
SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE lock modes No No No No No No No No Yes
Serializable Snapshot Isolation No No No No No No Yes Yes Yes
SP-GiST indexes for range types No No No No No No No No Yes
SQLDA support for ECPG No No No No No Yes Yes Yes Yes
SQL-standard information schema Yes Yes Yes Yes Yes Yes Yes Yes Yes
SQL standard interval handling No No No No Yes Yes Yes Yes Yes
Streaming-only cascading replication No No No No No No No No Yes
Streaming Replication No No No No No Yes Yes Yes Yes
Support for anonymous shared memory No No No No No No No No Yes
Synchronous replication No No No No No No Yes Yes Yes
TABLE statement No No No No Yes Yes Yes Yes Yes
Temporary VIEWs No Yes Yes Yes Yes Yes Yes Yes Yes
Two Phase commit No Yes Yes Yes Yes Yes Yes Yes Yes
Txid functions No No No Yes Yes Yes Yes Yes Yes
Typed tables No No No No No Yes Yes Yes Yes
UNNEST/array_agg No No No No Yes Yes Yes Yes Yes
Updatable views No No No No No No No No Yes
Updateable cursors No No No Yes Yes Yes Yes Yes Yes
Version aware psql No No No No Yes Yes Yes Yes Yes
Visibility map No No No No Yes Yes Yes Yes Yes
WAL-safe B-Tree Indexes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Warm Standby No No Yes Yes Yes Yes Yes Yes Yes
Window functions No No No No Yes Yes Yes Yes Yes
Writable Common Table Expressions No No No No No No Yes Yes Yes
Writable Foreign Data Wrappers No No No No No No No No Yes
XML, JSON and YAML output for EXPLAIN No No No No No Yes Yes Yes Yes
Performance 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3
Asynchronous Commit No No No Yes Yes Yes Yes Yes Yes
Automatic plan invalidation No No No Yes Yes Yes Yes Yes Yes
Background Checkpointer No No No No No No No Yes Yes
Background Writer Yes Yes Yes Yes Yes Yes Yes Yes Yes
Cross datatype hashing support No No No Yes Yes Yes Yes Yes Yes
Distributed checkpointing No No No Yes Yes Yes Yes Yes Yes
Foreign keys marked as NOT VALID No No No No No No Yes Yes Yes
Full Text Search No No No Yes Yes Yes Yes Yes Yes
GIN (Generalized Inverted Index) Indexes No No Yes Yes Yes Yes Yes Yes Yes
GIN indexes partial match No No No No Yes Yes Yes Yes Yes
GiST (Generalized Search Tree) Indexes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Hashing support for DISTINCT/UNION/INTERSECT/EXCEPT No No No No Yes Yes Yes Yes Yes
Hashing support for FULL OUTER JOIN, LEFT OUTER JOIN and RIGHT OUTER JOIN No No No No No No Yes Yes Yes
Hashing support for NUMERIC No No No Yes Yes Yes Yes Yes Yes
Heap Only Tuples (HOT) No No No Yes Yes Yes Yes Yes Yes
Indexes on expressions Yes Yes Yes Yes Yes Yes Yes Yes Yes
Index-only scans No No No No No No No Yes Yes
Index support for IS NULL No No No Yes Yes Yes Yes Yes Yes
Inlining of SQL-functions Yes Yes Yes Yes Yes Yes Yes Yes Yes
In-memory Bitmap Indexes No Yes Yes Yes Yes Yes Yes Yes Yes
K-nearest neighbor GiST support No No No No No No Yes Yes Yes
Lazy XID allocation No No No Yes Yes Yes Yes Yes Yes
Multi-core scalability for read-only workloads No No No No No No No Yes Yes
Multiple temporary tablespaces No No No Yes Yes Yes Yes Yes Yes
Non-blocking CREATE INDEX No No Yes Yes Yes Yes Yes Yes Yes
Outer Join reordering No No Yes Yes Yes Yes Yes Yes Yes
Parallel restore No No No No Yes Yes Yes Yes Yes
Partial sort capability (top-n sorting) No No No Yes Yes Yes Yes Yes Yes
SELECT ... FOR UPDATE/SHARE NOWAIT No Yes Yes Yes Yes Yes Yes Yes Yes
Semi- and Antijoins No No No No Yes Yes Yes Yes Yes
Shared row level locking No Yes Yes Yes Yes Yes Yes Yes Yes
Space-Partitioned GiST Indexes No No No No No No No Yes Yes
Synchronized sequential scanning No No No Yes Yes Yes Yes Yes Yes
Table partitioning No Yes Yes Yes Yes Yes Yes Yes Yes
Tablespaces Yes Yes Yes Yes Yes Yes Yes Yes Yes
Unlogged tables No No No No No No Yes Yes Yes
WAL Buffer auto-tuning No No No No No No Yes Yes Yes
Security 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3
GSSAPI support No No No Yes Yes Yes Yes Yes Yes
Large object access controls No No No No No Yes Yes Yes Yes
Native LDAP authentication No No Yes Yes Yes Yes Yes Yes Yes
Native RADIUS authentication No No No No No Yes Yes Yes Yes
Per user/database connection limits No Yes Yes Yes Yes Yes Yes Yes Yes
ROLES No Yes Yes Yes Yes Yes Yes Yes Yes
Search+bind mode operation for LDAP authentication No No No No No Yes Yes Yes Yes
security_barrier option on views No No No No No No No Yes Yes
Security Service Provider Interface (SSPI) No No No Yes Yes Yes Yes Yes Yes
SSL certificate validation in libpq No No No No Yes Yes Yes Yes Yes
SSL client certificate authentication No No No No Yes Yes Yes Yes Yes
SSPI authentication via GSSAPI No No No No No No Yes Yes Yes
Network 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3
Full SSL support Yes Yes Yes Yes Yes Yes Yes Yes Yes
IPv6 Support Yes Yes Yes Yes Yes Yes Yes Yes Yes
V2 client protocol Yes Yes Yes Yes Yes Yes Yes Yes Yes
V3 client protocol Yes Yes Yes Yes Yes Yes Yes Yes Yes
Internationalisation 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3
Column-level collation support No No No No No No Yes Yes Yes
Database level Collation No No No No Yes Yes Yes Yes Yes
EUC_JIS_2004/ SHIFT_JIS_2004 support No No No Yes Yes Yes Yes Yes Yes
Multibyte encoding support, incl. UTF8 Yes Yes Yes Yes Yes Yes Yes Yes Yes
Multiple language support Yes Yes Yes Yes Yes Yes Yes Yes Yes
Unicode string literals and identifiers No No No No Yes Yes Yes Yes Yes
UTF8 support on Windows No Yes Yes Yes Yes Yes Yes Yes Yes
Platforms 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3
Microsoft Visual C++ Support No No No Yes Yes Yes Yes Yes Yes
Native Windows Port Yes Yes Yes Yes Yes Yes Yes Yes Yes
Spinlock support for the SuperH hardware platform No No No No No Yes Yes Yes Yes
Sun Studio compiler on Linux No No No No Yes Yes Yes Yes Yes
Windows x64 support No No No No No Yes Yes Yes Yes
Datatypes 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3
Arrays of compound types No No No Yes Yes Yes Yes Yes Yes
Array support Yes Yes Yes Yes Yes Yes Yes Yes Yes
ENUM data type No No No Yes Yes Yes Yes Yes Yes
GUID/UUID data type No No No Yes Yes Yes Yes Yes Yes
IS0 8601 interval syntax No No No No Yes Yes Yes Yes Yes
JSON data type No No No No No No No Yes Yes
NULLs in Array No No Yes Yes Yes Yes Yes Yes Yes
Range types No No No No No No No Yes Yes
smallserial type No No No No No No No Yes Yes
Type modifier support No No No Yes Yes Yes Yes Yes Yes
XML data type No No No Yes Yes Yes Yes Yes Yes
Functions and triggers 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3
ALTER TABLE ENABLE/DISABLE TRIGGER No Yes Yes Yes Yes Yes Yes Yes Yes
ALTER TABLE / ENABLE REPLICA TRIGGER/RULE No No No Yes Yes Yes Yes Yes Yes
Column level triggers No No No No No Yes Yes Yes Yes
Event triggers No No No No No No No No Yes
Function argument names No No No No No Yes Yes Yes Yes
ORDER BY support within aggregates No No No No No Yes Yes Yes Yes
Per function GUC settings No No No Yes Yes Yes Yes Yes Yes
Per function statistics No No No No Yes Yes Yes Yes Yes
RETURN QUERY EXECUTE No No No No Yes Yes Yes Yes Yes
RETURNS TABLE No No No No Yes Yes Yes Yes Yes
Statement level triggers Yes Yes Yes Yes Yes Yes Yes Yes Yes
Statement level TRUNCATE triggers No No No No Yes Yes Yes Yes Yes
Triggers on views No No No No No No Yes Yes Yes
Variadic functions No No No No Yes Yes Yes Yes Yes
WHEN clause for CREATE TRIGGER No No No No No Yes Yes Yes Yes
Procedural Languages 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3
CASE in pl/pgsql No No No No Yes Yes Yes Yes Yes
CONTINUE statement for PL/pgSQL No Yes Yes Yes Yes Yes Yes Yes Yes
DO statement for pl/perl No No No No No Yes Yes Yes Yes
DO statement for pl/pgsql No No No No No Yes Yes Yes Yes
EXCEPTION support in PL/pgSQL Yes Yes Yes Yes Yes Yes Yes Yes Yes
EXECUTE USING in PL/pgSQL No No No No Yes Yes Yes Yes Yes
FOREACH IN ARRAY in pl/pgsql No No No No No No Yes Yes Yes
IN/OUT/INOUT parameters for pl/pgsql and PL/SQL No Yes Yes Yes Yes Yes Yes Yes Yes
Named parameters Yes Yes Yes Yes Yes Yes Yes Yes Yes
Non-superuser language creation No No No Yes Yes Yes Yes Yes Yes
Number of function arguments increased to 100 No Yes Yes Yes Yes Yes Yes Yes Yes
pl/pgsql installed by default No No No No No Yes Yes Yes Yes
Polymorphic functions Yes Yes Yes Yes Yes Yes Yes Yes Yes
Python 3 support for pl/python No No No No No Yes Yes Yes Yes
Qualified function parameters No No No Yes Yes Yes Yes Yes Yes
RETURN QUERY in pl/pgsql No No No Yes Yes Yes Yes Yes Yes
ROWS and COST specification for functions No No No Yes Yes Yes Yes Yes Yes
Scrollable and updatable cursor support for pl/pgsql No No No Yes Yes Yes Yes Yes Yes
SQLERRM/SQLSTATE for pl/pgsql No Yes Yes Yes Yes Yes Yes Yes Yes
Unicode object support in PL/python No No No No No Yes Yes Yes Yes
User defined exceptions No No No No Yes Yes Yes Yes Yes
Validator function for pl/perl No Yes Yes Yes Yes Yes Yes Yes Yes
contrib modules 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3
contrib/adminpack No No Yes Yes Yes Yes Yes Yes Yes
contrib/auth_delay No No No No No No Yes Yes Yes
contrib/autoexplain No No No No Yes Yes Yes Yes Yes
contrib/btree_gin No No No No Yes Yes Yes Yes Yes
contrib/btree_gist Yes Yes Yes Yes Yes Yes Yes Yes Yes
contrib/citext No No No No Yes Yes Yes Yes Yes
contrib/dblink Yes Yes Yes Yes Yes Yes Yes Yes Yes
contrib/dblink asyncronous notification support No No No No No Yes Yes Yes Yes
contrib/dbsize Yes Obsolete Obsolete Obsolete Obsolete Obsolete Obsolete Obsolete Obsolete
contrib/file_fdw No No No No No No Yes Yes Yes
contrib/fuzzystrmatch Yes Yes Yes Yes Yes Yes Yes Yes Yes
contrib/hstore No No Yes Yes Yes Yes Yes Yes Yes
contrib/hstore improvements No No No No No Yes Yes Yes Yes
contrib/intarray Yes Yes Yes Yes Yes Yes Yes Yes Yes
contrib/isn (ISBN) No No Yes Yes Yes Yes Yes Yes Yes
contrib/ltree Yes Yes Yes Yes Yes Yes Yes Yes Yes
contrib/pageinspect No No No Yes Yes Yes Yes Yes Yes
contrib/passwordcheck No No No No No Yes Yes Yes Yes
contrib/pg_autovacuum Yes Obsolete Obsolete Obsolete Obsolete Obsolete Obsolete Obsolete Obsolete
contrib/pgbench Yes Yes Yes Yes Yes Yes Yes Yes Yes
contrib/pg_buffercache No Yes Yes Yes Yes Yes Yes Yes Yes
contrib/pg_freespacemap No No Yes Yes Yes Yes Yes Yes Yes
contrib/pg_standby No No No Yes Yes Yes Yes Yes Yes
contrib/pg_stat_statements No No No No Yes Yes Yes Yes Yes
contrib/pg_stat_statements improvements No No No No No No No Yes Yes
contrib/pgstattuple Yes Yes Yes Yes Yes Yes Yes Yes Yes
contrib/pg_trgm Yes Yes Yes Yes Yes Yes Yes Yes Yes
contrib/pg_trgm regular expressions indexing No No No No No No No No Yes
contrib/pg_upgrade No No No No No Yes Yes Yes Yes
contrib/pg_xlogdump No No No No No No No No Yes
contrib/postgres_fdw No No No No No No No No Yes
contrib/seg Yes Yes Yes Yes Yes Yes Yes Yes Yes
contrib/sepgsql No No No No No No Yes Yes Yes
contrib/sslinfo No No Yes Yes Yes Yes Yes Yes Yes
contrib/tablefunc Yes Yes Yes Yes Yes Yes Yes Yes Yes
contrib/tcn No No No No No No No Yes Yes
contrib/tsearch2 Yes Yes Yes Obsolete Obsolete Obsolete Obsolete Obsolete Obsolete
contrib/tsearch2 compat wrapper No No No Yes Yes Yes Yes Yes Yes
contrib/tsearch2 UTF8 support No No Yes Obsolete Obsolete Obsolete Obsolete Obsolete Obsolete
contrib/unaccent No No No No No Yes Yes Yes Yes
contrib/userlocks Yes Yes Obsolete Obsolete Obsolete Obsolete Obsolete Obsolete Obsolete
contrib/uuid-ossp No No No Yes Yes Yes Yes Yes Yes
contrib/xml2 Yes Yes Yes Yes Obsolete Obsolete Obsolete Obsolete Obsolete

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group