In this tutorial, we will show you how to install PostgreSQL 11 on an Ubuntu 18.04 Cloud VPS. PostgreSQL is an open-source and general purpose object-relational database management system (ORDBMS).
The latest version of PostgreSQL, PostgreSQL 11, focuses on performance improvements. It comes packed with several advanced features and enhancements which include:
- Enhanced Capabilities for Query Parallelism which allows faster query execution
- Just-in-Time (JIT) compilation of SQL Statements
- Automatic index creation
- Advanced partitioning features
- Other performance improvements, like command line improvements, improved statistics and more…
Let’s start installing.