Entries by Martín Marqués

Untangling the PostgreSQL upgrade

September 30, 2016 /8 Comments/in , /by

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

September 20, 2016 /3 Comments/in /by

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