Upgrading PostgreSQL to 9.4

Preface

In 9.4 there is a logical decoding which would allow to upgrade from 9.4 to 9.5 quiet cheap (at least it shoud be so). But right now upgrading major version of PostgreSQL is painful. In most common case it looks like that:

  1. Stop master and call ...
more ...

PostgreSQL 9.4 and pg_repack

We have workflows with storing cooling UGC-data in DB. The older the data is, the less likely it is asked. We partition tables with such data by date and eventually move data from SSD-disks to SATA. It gives us very good hardware savings. PostgreSQL has built-in support for ...

more ...

Pgcheck and delayed replics

Two months ago we announced pgcheck - a tool for automatic load control on PostgreSQL databases using PL/Proxy. Today we have fixed all found issues about one new feature - pgcheck can now account replication delays and not to route queires on delayed replics.

Sources and some more info could be ...

more ...

PostgreSQL and SystemTap

Preface

Once upon a time we started having strange performance issues with writing-only load on PostgreSQL 9.4 with huge shared_buffers. The problem itself is well described here but it is not the topic of the post. And since PostgreSQL does not have something like Oracle wait events interface yet ...

more ...

Yet another psql color prompt

Below are screenshots and configs for yet another color prompting of psql. The goal was to get the color prompting scheme that works well on both light and dark background terminals.

Here is an example of .bashrc file:

#!/bin/bash

export YELLOW=`echo -e '\033[1;33m'`
export LIGHT_CYAN=`echo ...
more ...