PostgreSQL 10 – other highlights

View “pg_stat_activity” contains new useful or updated existing columns which can help us to better track what is going on in the database: wait_event_type – has now interesting values “Activity”, “Extension”,...

PostgreSQL 10 – table partitioning – first impressions

PostgreSQL 10 comes with nice new native partitioning. This new partitioning does not need any triggers. It distributes inserted records automatically to the proper partitions. Here are some first impressions from tests: Create parent table: create table public.test...

Install PostgreSQL 10 beta from sources – on Debian 8

Installation from source is described in documentation. I tested on GCE instance with Debian 8. Here is just quick summary: download tar with source: wget https://ftp.postgresql.org/pub/source/v10beta1/postgresql-10beta1.tar.gz untar it: tar xvfz...

PostgreSQL and MySQL on cloud instances – few small hints

Many companies use in these days cloud instances which allows them to live without stress from maintaining their own infrastructure. On the other hand it gives them new kinds of stress when internet connection is not working etc. I have now (2016/11) 8 month...