PgBouncer is a lightweight connection pooler for PostgreSQL. PgBouncer 1.7 was announced on the 18th of December 2015. In this blog post we’ll talk about the major new improvements in PgBouncer. The Most Colorful Features PgBouncer 1.7 supports TLS connections and, I think this is the biggest improvement of the new release. They used OpenSSL/LibreSSL libraries as backend implementation of the...

Ansible Galaxy is simply the easiest way of finding already written Ansible roles, creating and sharing your roles and jump into the galaxy of Ansible content! ==================== Prime time announcement ! ==================== FOSDEM PGDay 2016 will be on 29th of January before FOSDEM which is Europe’s biggest open source event and PostgreSQL Devroom will be on 31st of January at FOSDEM in...

Ansible is simply great and PostgreSQL is surely awesome, let’s see how they work amazingly together! ==================== Prime time announcement ! ==================== PGConf Europe 2015 will be on 27th-30th of October in Vienna this year. I assume you’re possibly interested in configuration management, server orchestration, automated deployment (that’s why you’re reading this blog post, right?)...

PostgreSQL’s TABLESAMPLE brings a few more advantages compared to other traditional ways for getting random tuples. TABLESAMPLE is a SQL SELECT clause and it provides two sampling methods which are SYSTEM and BERNOULLI. With the help of TABLESAMPLE we can easily retrieve random rows from a table. For further reading about TABLESAMPLE you can check the previous blog post . In this blog post we’ll...

PgBouncer is a lightweight connection pooler for PostgreSQL. PgBouncer 1.6 was announced on the 1st of August 2015. In this blog post we’ll talk about the major new improvements in PgBouncer. Main new features of PgBouncer Load user password hash from postgres database PgBouncer now allows loading the user’s password from the database with two config parameters which are auth_user and auth_query...

PostgreSQL 9.5 introduces support for TABLESAMPLE, an SQL SELECT clause that returns a random sample from a table. SQL:2003 defines two sampling methods: SYSTEM and BERNOULLI. The SYSTEM method uses random IO whereas BERNOULLI uses sequential IO. SYSTEM is faster, but BERNOULLI gives us a much better random distribution because each tuple (row) has the same probability on being selected. The...