The latest Barman 2.10 release introduces support for the system identifier of a PostgreSQL instance. In this article, I will answer a few questions explaining what a system identifier is and why it is a good thing that Barman uses it. What is the PostgreSQL system identifier? PostgreSQL gives a unique system identifier to every […]
PostgreSQL’s TABLESAMPLE brings a few more advantages compared to other traditional ways for getting random tuples.
PostgreSQL 9.5 introduces support for TABLESAMPLE, an SQL SELECT clause that returns a random sample from a table.