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 ...

Pgcheck

A month ago I spoke about first steps in Yandex.Mail with PostgreSQL and particularly about our tools to provide fault tolerance. One of them is pgcheck - tool for monitoring backend databases from PL/Proxy hosts and changing plproxy.get_cluster_partitions function output to for controlling load on databases.

More info ...

more ...