Infrastructure at your Service

PostgreSQL Archives - Page 3 of 23 - Blog dbi services

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
Daniel Westermann

EDB Failover Manager in EDB containers in Minishift/OpenShift – Failovers

By | Database Administration & Monitoring | No Comments

In the last post we had a look at the basic configuration of EDB EFM and confirmed that we can do manual switchovers for maintenance operations. Being able to do a switchover and switchback is fine but what really is important are automatic failovers. Without an automatic failover this setup would be somehow useless as a) EDB EFM is supposed to do exactly that and b) without that we would need to implement something on…

Read More
Oracle Team

Postgres, the fsync() issue, and ‘pgio’ (the SLOB method for PostgreSQL)

By | Postgres | 2 Comments

By Franck Pachot . That’s a long blog post title, which is actually just a good pretext to play with Kevin Closson SLOB method for PostgreSQL: pgio I use the beta version of pgio here. If you want to read more about it, you can start on https://kevinclosson.net/2018/05/22/sneak-preview-of-pgio-the-slob-method-for-postgressql-part-i-the-beta-pgio-readme-file/. If you are used to the SLOB for Oracle (https://kevinclosson.net/slob/) you will quickly understand the ‘why’ and ‘how’ of pgio.

Read More