PostgreSQL

PostgreSQL 14: LZ4 compression for TOAST

In PostgreSQL a row or tuple can not span multiple pages (a page is typically 8kB), but of course you can store larger rows and PostgreSQL brakes and compresses these rows into smaller chunks by using a technique called(…)

Getting started with the Zalando Operator for PostgreSQL

In the previous posts (Rancher, up and running, on EC2 – 1 – One node, Rancher, up and running, on EC2 – 2 – Three nodes, Rancher, up and running, on(…)

AWS: PostgreSQL on Graviton2 with newer GCC

By Franck Pachot . In the previous post I have run PostgreSQL on AWS m6gd.2xlarge (ARM Graviton2 processor). I didn’t precise the compilation option and this post will give more details following this feedback:(…)

AWS: PostgreSQL on Graviton2

By Franck Pachot . On the AWS free tier, you can run a t2.micro instance for 750 hours per month during the first 12 month after sign-up date. And currently, until June 2021, you can also run a(…)

Be careful with prepared transactions in PostgreSQL

PostgreSQL gives you the possibility for two-phase commit. You'll might need that if you want an atomic distributed commit. If you check the PostgreSQL documentation there is a clear warning about using these kind(…)

[Data]nymizer – Data anonymizer for PostgreSQL

Often there is the requirement to populate a test or development database with data from production, but this comes with a risk: Do you really want, that developers or testers have access to sensitive data? In a lot of companies(…)

8000 PostgreSQL clusters on one host?

Coming back to the last post: 8000 databases in one PostgreSQL cluster?. As we've seen this is doable but comes with a lot of pain points. Another solution for this kind of requirement would be to host(…)

PostgreSQL on FreeBSD, installation from source code

This is the next post in this little series about PostgreSQL on FreeBSD. You can find the previous one here: PostgreSQL on FreeBSD, getting started PostgreSQL on FreeBSD, updating & configuration(…)

PostgreSQL on FreeBSD, installation from packages

In the last two posts we installed FreeBSD, configured networking, updated the system, installed bash and had a quick look at kernel parameters. In this post we'll install PostgreSQL from packages. Of course you(…)

PostgreSQL on FreeBSD, updating & configuration

In the last post we installed FreeBSD, configured the keyboard, time zone and the first network interface, which gets it's IP address via DHCP. In this post we'll look at how we can configure the second interface,(…)