Infrastructure at your Service

PostgreSQL Archives - Page 2 of 22 - Blog dbi services

Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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 11, what happens when we change that default afterwards? Does the table get rewritten? Do we have more than on distinct default value for that column? Here we go …  

 
Read More
Daniel Westermann

What a great event – PGDay Amsterdam

By | Database Administration & Monitoring | No Comments

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 impressions: Here you can see Devrim preparing the opening of the event with the introduction session: … and then it happened: We finally started: Jan kicked of the sessions with his talk about the reasons he finally arrived in the PostgreSQL community…

 
Read More
Oracle Team

pgSentinel: the sampling approach for PostgreSQL

By | Database Administration & Monitoring, Postgres | 3 Comments

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 that has made our life a lot easier to optimize database applications. Here is a quick example showing how it links together some information that are missing without this extension.  

 
Read More
Daniel Westermann

Active session history in PostgreSQL: Say hello to pgSentinel

By | Database Administration & Monitoring | No Comments

There is new project, currently in beta, which aims to bring active session history (and probably more) to PostgreSQL: pgSentinel. Because PostgreSQL is highly extensible such projects are possible and usually are coming as an extension. pgSentinel is no exception to that so lets see how it can be installed. When you want to try the beta for your own, please connect with the project on twitter.  

 
Read More
Daniel Westermann

Do you need the same column with the same check constraint twice? Create a domain!

By | Database Administration & Monitoring | No Comments

Did you know that you can create domains in PostgreSQL? No, nothing to worry about. We’ll take Frank’s leave for a new opportunity as a chance to introduce the concept of domains. @Franck: Yes, although we all fully understand your decision and the reasons to move on to a new challenge, this post is dedicated to you and you need to be the example in the following little demo. Lets go …  

 
Read More
Daniel Westermann

How to compile PostgreSQL 11 with support for JIT compilation on RHEL/CentOS 7

By | Database Administration & Monitoring | No Comments

As you might already know PostgreSQL 11 will bring support for just-in-time compilation. When you want to compile PostgreSQL 11 with jit support on RedHat/CentOS 7 this requires a little hack (more on the reason below). In this post we’ll look at how you can do it at least for testing. For production it is of course not recommended as hacking the make file is nothing you want to do, at least I would not…

 
Read More
Daniel Westermann

PostgreSQL 11: Instant add column with a non null default value

By | Database Administration & Monitoring | No Comments

As I am currently preparing my session for the Swiss PGDay which is about some of the new features for PostgreSQL 11, I though this one is worth a blog post as well. Up to PostgreSQL 10 when you add a column to table which has a non null default value the whole table needed to be rewritten. With PostgreSQL 11 this is not anymore the case and adding a column in such a way…

 
Read More