PostgreSQL 9.6 has just been released and most of the postgres users will start asking themselves how to upgrade to the new major version. This post has the intention of showing different procedures for upgrading your PostgreSQL server. Upgrading to a new major version is a task which has a high ratio of preparation over […]
About Martín Marqués
Martín Marqués is a PostgreSQL enthusiast and contributes regularly to 2ndQuadrant blog.
Intro PostgreSQL gives developers the chance of choosing between two possible storage facilities for large binary data: Bytea and LargeObjects. Large Objects have been around for a long time, and PostgreSQL has a smart way of storing large binary data. It does so by splitting it into chunks of LOBLKSIZE (a forth of BLCKSZ). That […]