2. Difference betweenPostgres Pro and PostgreSQL
Postgres Pro provides the most actualPostgreSQL version with some additional patches applied and extensions added. It includes new features developed by Postgres Professional, as well as third-party patches already accepted by the PostgreSQL community for the upcomingPostgreSQL versions.Postgres Pro users thus have early access to important features and fixes.
Note
Postgres Pro is provided under the following license:https://postgrespro.com/products/postgrespro/eula. Make sure to review the license terms before downloadingPostgres Pro.
Postgres Pro provides the following enhancements overPostgreSQL:
- 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. (See the
INCLUDINGdescription inCREATE INDEX.) - ICU collation support on all platforms to provide platform-independent sort for various locales. The
icucollation provider is used for all locales exceptCandPOSIX. - pg_trgm module supporting fuzzy string comparison and substring search.
- Improvedpageinspect module that provides access to internal data storage structure.
- sr_plan module that allows to save and restore query plans.
- dump_stat module that allows to save and restore database statistics when dumping/restoring the database.
- jsquery module that provides a specific language for effective index-supported querying of JSONB data.
Postgres Pro releases followPostgreSQL releases, though sometimes occur more frequently. ThePostgres Pro versioning scheme is based on thePostgreSQL one and has an additional decimal place.