PostgreSQL veritabanı özellik matrisi

Backend

	14	13	12	11	10
64-bit large objects	Yes	Yes	Yes	Yes	Yes
Advisory locks	Yes	Yes	Yes	Yes	Yes
Autovacuum enabled by default	Yes	Yes	Yes	Yes	Yes
Custom background workers	Yes	Yes	Yes	Yes	Yes
Disk based FSM	Yes	Yes	Yes	Yes	Yes
Dollar Quoting	Yes	Yes	Yes	Yes	Yes
Dynamic Background Workers	Yes	Yes	Yes	Yes	Yes
EXPLAIN (BUFFERS) support	Yes	Yes	Yes	Yes	Yes
EXPLAIN (WAL) support	Yes	Yes	No	No	No
Holdable cursors	Yes	Yes	Yes	Yes	Yes
Inserted data can trigger autovacuum	Yes	Yes	No	No	No
Integrated autovacuum daemon	Yes	Yes	Yes	Yes	Yes
Loadable plugin infrastructure for monitoring the planner	Yes	Yes	Yes	Yes	Yes
Multiple autovacuum workers	Yes	Yes	Yes	Yes	Yes
Named restore points	Yes	Yes	Yes	Yes	Yes
Parallelized VACUUM for Indexes	Yes	Yes	No	No	No
Parallel vacuumdb jobs	Yes	Yes	Yes	Yes	Yes
Payload support for LISTEN/NOTIFY	Yes	Yes	Yes	Yes	Yes
Prefix support for text search synonym dictionary	Yes	Yes	Yes	Yes	Yes
Savepoints	Yes	Yes	Yes	Yes	Yes
Serializable Snapshot Isolation	Yes	Yes	Yes	Yes	Yes
SQLDA support for ECPG	Yes	Yes	Yes	Yes	Yes
SQL-standard information schema	Yes	Yes	Yes	Yes	Yes
Support for anonymous shared memory	Yes	Yes	Yes	Yes	Yes
Two Phase commit	Yes	Yes	Yes	Yes	Yes
unnest/array_agg	Yes	Yes	Yes	Yes	Yes
Updateable cursors	Yes	Yes	Yes	Yes	Yes
Vacuum “emergency mode”	Yes	No	No	No	No
Version aware psql	Yes	Yes	Yes	Yes	Yes
Visibility Map for Vacuuming	Yes	Yes	Yes	Yes	Yes
XML, JSON and YAML output for EXPLAIN	Yes	Yes	Yes	Yes	Yes

Data Types, Functions, & Operators

	14	13	12	11	10
Arrays of compound types	Yes	Yes	Yes	Yes	Yes
Array support	Yes	Yes	Yes	Yes	Yes
ENUM data type	Yes	Yes	Yes	Yes	Yes
GUID/UUID data type	Yes	Yes	Yes	Yes	Yes
Improved set of JSON functions and operators	Yes	Yes	Yes	Yes	Yes
JSONB data type	Yes	Yes	Yes	Yes	Yes
JSONB-modifying operators and functions	Yes	Yes	Yes	Yes	Yes
JSONB Subscripting	Yes	No	No	No	No
JSON data type	Yes	Yes	Yes	Yes	Yes
macaddr8 data type	Yes	Yes	Yes	Yes	Yes
Multiranges	Yes	No	No	No	No
NULLs in Array	Yes	Yes	Yes	Yes	Yes
Phrase search	Yes	Yes	Yes	Yes	Yes
Range types	Yes	Yes	Yes	Yes	Yes
smallserial type	Yes	Yes	Yes	Yes	Yes
SQL/JSON: datetime()	Yes	Yes	No	No	No
Type modifier support	Yes	Yes	Yes	Yes	Yes
XML data type	Yes	Yes	Yes	Yes	Yes

Indexing & Constraints

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

SQL

	14	13	12	11	10
FETCH FIRST .. WITH TIES	Yes	Yes	No	No	No
GROUPING SETS, CUBE and ROLLUP support	Yes	Yes	Yes	Yes	Yes
INSERT/UPDATE/DELETE RETURNING	Yes	Yes	Yes	Yes	Yes
LATERAL clause	Yes	Yes	Yes	Yes	Yes
Multirow VALUES	Yes	Yes	Yes	Yes	Yes
ORDER BY NULLS FIRST/LAST	Yes	Yes	Yes	Yes	Yes
Recursive Queries	Yes	Yes	Yes	Yes	Yes
Row-wise comparison	Yes	Yes	Yes	Yes	Yes
SELECT FOR NO KEY UPDATE/SELECT FOR KEY SHARE lock modes	Yes	Yes	Yes	Yes	Yes
SQL/JSON path expressions	Yes	Yes	Yes	No	No
SQL standard interval handling	Yes	Yes	Yes	Yes	Yes
TABLE statement	Yes	Yes	Yes	Yes	Yes
Upsert (INSERT … ON CONFLICT DO …)	Yes	Yes	Yes	Yes	Yes
Window functions	Yes	Yes	Yes	Yes	Yes
WITHIN GROUP clause	Yes	Yes	Yes	Yes	Yes
WITH ORDINALITY clause	Yes	Yes	Yes	Yes	Yes
WITH Queries (Common Table Expressions)	Yes	Yes	Yes	Yes	Yes
Writable WITH Queries (Common Table Expressions)	Yes	Yes	Yes	Yes	Yes

Data Definition Language (DDL)

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

Performance

	14	13	12	11	10
Abbreviated Keys	Yes	Yes	Yes	Yes	Yes
Accelerated partition pruning	Yes	Yes	Yes	No	No
Asynchronous Commit	Yes	Yes	Yes	Yes	Yes
Automatic plan invalidation	Yes	Yes	Yes	Yes	Yes
Background Checkpointer	Yes	Yes	Yes	Yes	Yes
Background Writer	Yes	Yes	Yes	Yes	Yes
Base backup throttling	Yes	Yes	Yes	Yes	Yes
CREATE STATISTICS – most-common values (MCV) statistics	Yes	Yes	Yes	No	No
CREATE STATISTICS – multicolumn	Yes	Yes	Yes	Yes	Yes
CREATE STATISTICS – “OR” and “IN/ANY” statistics	Yes	Yes	No	No	No
Cross datatype hashing support	Yes	Yes	Yes	Yes	Yes
Distributed checkpointing	Yes	Yes	Yes	Yes	Yes
Foreign keys marked as NOT VALID	Yes	Yes	Yes	Yes	Yes
Frozen page map	Yes	Yes	Yes	Yes	Yes
Full Text Search	Yes	Yes	Yes	Yes	Yes
Hash aggregation can use disk	Yes	Yes	No	No	No
Hashing support for DISTINCT/UNION/INTERSECT/EXCEPT	Yes	Yes	Yes	Yes	Yes
Hashing support for FULL OUTER JOIN, LEFT OUTER JOIN and RIGHT OUTER JOIN	Yes	Yes	Yes	Yes	Yes
Heap Only Tuples (HOT)	Yes	Yes	Yes	Yes	Yes
Incremental sort	Yes	Yes	No	No	No
Incremental sort for window functions	Yes	No	No	No	No
Inlined WITH Queries (Common Table Expressions)	Yes	Yes	Yes	No	No
Inlining of SQL-functions	Yes	Yes	Yes	Yes	Yes
Just-in-Time (JIT) compilation for expression evaluation and tuple deforming	Yes	Yes	Yes	Yes	No
K-nearest neighbor GiST support	Yes	Yes	Yes	Yes	Yes
LZ4 compression for TOAST tables	Yes	No	No	No	No
Multi-core scalability for read-only workloads	Yes	Yes	Yes	Yes	Yes
Multiple temporary tablespaces	Yes	Yes	Yes	Yes	Yes
Outer Join reordering	Yes	Yes	Yes	Yes	Yes
Parallel bitmap heap scans	Yes	Yes	Yes	Yes	Yes
Parallel full table scans (sequential scans)	Yes	Yes	Yes	Yes	Yes
Parallel hash joins	Yes	Yes	Yes	Yes	No
Parallel JOIN, aggregate	Yes	Yes	Yes	Yes	Yes
Parallel merge joins	Yes	Yes	Yes	Yes	Yes
Parallel query	Yes	Yes	Yes	Yes	Yes
Parallel restore	Yes	Yes	Yes	Yes	Yes
Partial sort capability (top-n sorting)	Yes	Yes	Yes	Yes	Yes
Partition pruning during query execution	Yes	Yes	Yes	Yes	No
pg_prewarm	Yes	Yes	Yes	Yes	Yes
Query pipelining	Yes	No	No	No	No
Reduced lock levels for ALTER TABLE commands	Yes	Yes	Yes	Yes	Yes
SELECT … FOR UPDATE/SHARE NOWAIT	Yes	Yes	Yes	Yes	Yes
Set costs specific to TABLESPACEs	Yes	Yes	Yes	Yes	Yes
Shared row level locking	Yes	Yes	Yes	Yes	Yes
SKIP LOCKED clause	Yes	Yes	Yes	Yes	Yes
Synchronized sequential scanning	Yes	Yes	Yes	Yes	Yes
TABLESAMPLE clause	Yes	Yes	Yes	Yes	Yes
Tablespaces	Yes	Yes	Yes	Yes	Yes
Unlogged tables	Yes	Yes	Yes	Yes	Yes
WAL Buffer auto-tuning	Yes	Yes	Yes	Yes	Yes

Partitioning & Inheritance

	14	13	12	11	10
Declarative table partitioning	Yes	Yes	Yes	Yes	Yes
Default Partition	Yes	Yes	Yes	Yes	No
Foreign Key references for partitioned tables	Yes	Yes	Yes	No	No
Foreign table inheritance	Yes	Yes	Yes	Yes	Yes
Logical Replication for Partitioned Tables	Yes	Yes	No	No	No
Partitioning by a hash key	Yes	Yes	Yes	Yes	No
Support for PRIMARY KEY, FOREIGN KEY, indexes, and triggers on partitioned tables	Yes	Yes	Yes	Yes	No
Table Partitioning	Yes	Yes	Yes	Yes	Yes
UPDATE on a partition key	Yes	Yes	Yes	Yes	No

Views & Materialized Views

	14	13	12	11	10
Materialized Views	Yes	Yes	Yes	Yes	Yes
Materialized views with concurrent refresh	Yes	Yes	Yes	Yes	Yes
Temporary VIEWs	Yes	Yes	Yes	Yes	Yes
Updatable views	Yes	Yes	Yes	Yes	Yes
WITH CHECK clause	Yes	Yes	Yes	Yes	Yes

Backup, Restore, Data Integrity, & Replication

	14	13	12	11	10
Cascading streaming replication	Yes	Yes	Yes	Yes	Yes
Checksum on data pages	Yes	Yes	Yes	Yes	Yes
Configure max WAL retention for replication slots	Yes	Yes	No	No	No
Enable/Disable page checksums in an offline cluster	Yes	Yes	Yes	No	No
Generic WAL facility	Yes	Yes	Yes	Yes	Yes
Hot Standby	Yes	Yes	Yes	Yes	Yes
Logical Replication	Yes	Yes	Yes	Yes	Yes
Logical replication stream in-progress transactions	Yes	No	No	No	No
min_wal_size / max_wal_size	Yes	Yes	Yes	Yes	Yes
Multiple synchronous standbys	Yes	Yes	Yes	Yes	Yes
Parallel pg_dump	Yes	Yes	Yes	Yes	Yes
pg_basebackup tool	Yes	Yes	Yes	Yes	Yes
pg_receivewal (formerly pg_receivexlog)	Yes	Yes	Yes	Yes	Yes
Point-in-Time Recovery	Yes	Yes	Yes	Yes	Yes
Quorum commit for synchronous replication	Yes	Yes	Yes	Yes	Yes
remote_apply mode	Yes	Yes	Yes	Yes	Yes
Replication Slots	Yes	Yes	Yes	Yes	Yes
Streaming-only cascading replication	Yes	Yes	Yes	Yes	Yes
Streaming Replication	Yes	Yes	Yes	Yes	Yes
Synchronous replication	Yes	Yes	Yes	Yes	Yes
Time-delayed Standbys	Yes	Yes	Yes	Yes	Yes
Verify backup integrity (pg_verifybackup)	Yes	Yes	No	No	No
Warm Standby	Yes	Yes	Yes	Yes	Yes

Data Import & Export

	14	13	12	11	10
COPY from/to STDIN/STDOUT	Yes	Yes	Yes	Yes	Yes
COPY FROM … WHERE	Yes	Yes	Yes	No	No
COPY with arbitrary SELECT	Yes	Yes	Yes	Yes	Yes
CSV support for COPY	Yes	Yes	Yes	Yes	Yes

Configuration Management

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

Security

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

Foreign Data Wrappers

	14	13	12	11	10
Certificate authentication with postgres_fdw	Yes	Yes	No	No	No
Foreign data wrapper query parallelism	Yes	No	No	No	No
Foreign data wrappers	Yes	Yes	Yes	Yes	Yes
Foreign Tables	Yes	Yes	Yes	Yes	Yes
IMPORT FOREIGN SCHEMA	Yes	Yes	Yes	Yes	Yes
Import foreign table partitions	Yes	No	No	No	No
Parallel query execution on remote databases	Yes	No	No	No	No
postgres_fdw pushdown	Yes	Yes	Yes	Yes	Yes
PostgreSQL Foreign Data Wrapper	Yes	Yes	Yes	Yes	Yes
Writable Foreign Data Wrappers	Yes	Yes	Yes	Yes	Yes

Custom Functions, Stored Procedures, & Triggers

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

Procedural Languages

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

Extensions

	14	13	12	11	10
CREATE EXTENSION .. CASCADE	Yes	Yes	Yes	Yes	Yes
Extension Installation	Yes	Yes	Yes	Yes	Yes
Trusted Extensions	Yes	Yes	No	No	No

Internationalisation

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

Additional Modules (contrib)

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

Network

	14	13	12	11	10
Full SSL support	Yes	Yes	Yes	Yes	Yes
IPv6 Support	Yes	Yes	Yes	Yes	Yes
V3 client protocol	Yes	Yes	Yes	Yes	Yes

Platforms

	14	13	12	11	10
Microsoft Visual C++ Support	Yes	Yes	Yes	Yes	Yes
Native Windows Port	Yes	Yes	Yes	Yes	Yes
Spinlock support for the SuperH hardware platform	Yes	Yes	Yes	Yes	Yes
Sun Studio compiler on Linux	Yes	Yes	Yes	Yes	Yes
Windows x64 support	Yes	Yes	Yes	Yes	Yes