PostgreSQL is a database software that can be installed on various types of operating systems. The operating system and database software are further deployed on hardware such as a server, a virtual machine, or a user's computer.
There were days when PostgreSQL ran on old-school hard disks that were considered to be slow for random page fetches (index scans). Now, the assumption of an optimizer that index scans are costly may change if we are using SSDs for database servers. Additionally, an increase in the hardware capacity also gives a lot of room for new features and parallel processing in database software such as PostgreSQL. Any such modifications to the database software will be made available through new releases. ...
