April 2018
Intermediate to advanced
508 pages
15h 22m
English
One habit some database deployments adopt, which is counterproductive with PostgreSQL, is that the version of the software used should be frozen forever once the system is validated as working. This is a particularly troublesome viewpoint to adopt for systems that run into performance issues. The performance increases that you'll find just from upgrading from older to newer PostgreSQL versions can be far larger than anything you can do just by tweaking the older version. Similarly, if you're running into a problem with how a specific query is executing, don't be surprised to find that it's fixed in a later version of PostgreSQL, and upgrading to it is really your only option to obtain that fix.
While ...