PostgreSQL

Using the managed PostgreSQL service in Azure

In the last post we had a look on how you can bring up a customized PostgreSQL instance in the Azure cloud. Now I want to check what you can do with the managed service. For(…)

Bringing up your customized PostgreSQL instance on Azure

The Azure cloud becomes more and more popular so I gave it try and started simple. The goal was to provision a VM, compiling and installing PostgreSQL and then connecting to the instance. There is also a fully(…)

Backing up and restoring EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. The last blogs in the series are already some days old: Setting up MiniShift,(…)

When does PostgreSQL create the table and index files on disk?

A question that pops up from time to time is: When we create a table or an index in PostgreSQL are the files on disk created immediately or is this something that happens when the first row is inserted? The(…)

Syncing Active Directory users and groups to PostgreSQL

A lot of companies use Active Directory to manage their users and groups. What most of this companies also want to do is to manage their database users and groups in Active Directory. PostgreSQL comes with(…)

Drilling down the pgSentinel Active Session History

By Franck Pachot . In pgSentinel: the sampling approach for PostgreSQL I mentioned that one of the advantages of the ASH approach is the ability to drill down from an overview of the database activity,(…)

PGDay Amsterdam – follow up 2 – Where do null values go to in a hash partitioned table?

This is the second follow up which covers this question: When you hash partition a table in PostgreSQL 11 where do null values for the partitioned column go to? Lets go...

PGDay Amsterdam – follow up 1 – Adding columns with a default value and changing the default value right after

As always, this time during my talk about the PostgreSQL 11 new features in Amsterdam, there have been question I could not immediately answer. The first one was this: Suppose we add a column with a default value in PostgreSQL(…)

What a great event – PGDay Amsterdam

PostgreSQL conferences are always cool and this time it was in Amsterdam: PGDay Amsterdam. Beside that meeting all the great people was fun again the location was really outstanding: The TOBACCO Theater: Some(…)

pgSentinel: the sampling approach for PostgreSQL

By Franck Pachot . Here is the first test I did with the beta of pgSentinel. This Active Session History sampling is a new approach to Postgres tuning. For people coming from Oracle, this is something(…)