2.  Difference between Postgres Pro Standard and PostgreSQL

Postgres Pro provides the most actual PostgreSQL version with some additional patches applied and extensions added. Mostly, these are patches already accepted by the PostgreSQL community and committed into PostgreSQL. Also there some patches and extensions developed by Postgres Professional. Users of Postgres Pro thus have early access to some important features and fixes.

Currently the difference between Postgres Pro Standard and PostgreSQL is the following:

  • Performance improvement on multicore systems (buffer manager and locks optimization)
  • Full text search improvements: phrase search, hunspell morphology, some dictionaries are bundled with distribution and can be enabled by a single SQL statement, shared_ispell allowing to store dictionaries in shared memory
  • Covering indexes
  • libicu support on all platforms, providing platform-independent sort for various locales
  • pg_trgm module supporting fuzzy string comparison and substring search
  • Improved pageinspect module provides access to internal data storage structure
  • sr_plan module allows to save and restore query plans
  • dump_stat module allowing to save and restore database statistics when dumping/restoring the database
  • jsquery module provides a specific language for effective index-supported querying of JSONB data
  • pg_variables module provides functions to work with variables of various types
  • pg_pathman module provides optimized partitioning mechanism and functions to manage partitions
  • pg_query_state module provides a facility to know the current state of query execution on working backend
  • pg_probackup is a backup and recovery manager
  • mchar module provides additional data type to compatibility with Microsoft SQL Server
  • fulleq module provides additional equivalence operator to compatibility with Microsoft SQL Server
  • fasttrun module provides transaction unsafe function to truncate temporary tables without growing pg_class size
  • online_analyze module provides set of changes, which immediately update stats after INSERT, UPDATE, DELETE or SELECT INTO operations applied for affected tables
  • plantuner module provides hits for planner, which can do disable or enable indexes for query execution
  • pg_tsparser module is an alternative text search parser

Postgres Pro Standard releases are following the PostgreSQL releases, though sometimes occur more frequently. The Postgres Pro Standard versioning scheme is based on the PostgreSQL one and has an additional decimal place.