PostgreSQL vs. Linux kernel versions

I’ve published multiple benchmarks comparing different PostgreSQL versions, as for example the performance archaeology talk (evaluating PostgreSQL 7.4 up to 9.4), and all those benchmark assumed fixed environment (hardware, kernel, …). Which is fine in many cases (e.g. when evaluating performance impact of a patch), but on production those things do change over time – […]

Conference isn’t enough?! Join us for post-conference training!

Did you know – 2ndQuadrant has the largest single, collection of PostgreSQL experts of any company globally?! With a team of some of the best known developers, they all still actively contribute to the progressive development of PostgreSQL. Would you like to have access to some of the most knowledgeable and experienced people available? The […]

Keen on Kanban? The 5432…MeetUs! Conference can teach you everything you need to know!

Keynote speakers are always something everyone looks forward to at conferences.  We’re particularly looking forward to seeing Dragos Dumitriu team up with our very own Gabriele Bartolini at the 5432…MeetUs! conference in Milan, Italy June 28 and 29. Dragos Dumitriu is an industry leader in the Agile community and renowned Kanban expert – helping to improve […]

Tracing PostgreSQL with perf

The profiling utility perf that ships with the Linux kernel is extremely useful for examining system-wide and multi-process behaviour – but it does a lot more than the CPU profiling it’s often used for. You’ve probably looked at perf top -az or perf top -u postgres output, but that’s only the littlest bit of what […]

Postgres and devops: testing 9.3 with Vagrant and Puppet – part one

My top #1 open source tool that I have discovered in the last year is definitely Vagrant. Vagrant is a software that helps you build and configure virtual environments for development and testing purposes. Vagrant relies on virtual machine providers such as VirtualBox, VMWare and AWS, as well as provisioning tools such as Chef and […]

Managing the backup of several PostgreSQL servers with Barman

One of the key aspects of Barman is the possibility to remotely backup multiple PostgreSQL servers from one single backup host. The upcoming version 1.1.2 of Barman will make this much easier from a system administrator’s point of view. Let’s see why.

How to install multiple PostgreSQL servers on RedHat Linux

If you have a Linux server of the RedHat family (inclusing CentOS and Fedora), you might envy the way Debian/Ubuntu distributions handle PostgreSQL clusters management. Although it is not easy to install different PostgreSQL versions on the same RedHat Linux server using RPMs, it is much simpler to install several instances of PostgreSQL (servers) and, […]