Entries by Martín Marqués

Untangling the PostgreSQL upgrade

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 […]

Those darn Large Objects

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 […]