PostgreSQL

AWS Aurora IO:XactSync is not a PostgreSQL wait event

By Franck Pachot . In AWS RDS you can run two flavors of the PostgreSQL managed service: the real PostgreSQL engine, compiled from the community sources, and running on EBS storage mounted by the database EC2 instance, and the(…)

ysql_bench: the YugaByteDB version of pgbench

By Franck Pachot . This follows the previous post on testing YugaByteDB 2.1 performance with pgbench: https://www.dbi-services.com/blog/yugabytedb-2-1/ A distributed database needs to reduce inter-node synchronization latency and then replaces two-phase pessimistic locking by(…)

YugaByteDB 2.1: the Open Source multi-region distributed database with PostgreSQL API is in GA with huge performance improvement

By Franck Pachot . 9 months ago I was looking at YugaByteDB which was still in beta version for its 'YSQL' API. I published my first test on Medium: https://medium.com/@FranckPachot/running-pgbench-on-yugabytedb-1-3-3a15450dfa42. I have been very enthusiastic about(…)

Control-M/EM Mass update,some examples on how to use it

Introduction We are back today to write about a powerful tool that we can use to update our folders Question Suppose you have to update two jobs of your folder; the task should be easy But what happens when you(…)

How SQL Server MVCC compares to Oracle and PostgreSQL

By Franck Pachot . Microsoft SQL Server has implemented MVCC in 2005, which has been proven to be the best approach for transaction isolation (the I in ACID) in OLTP. But are you sure that writers do not block readers(…)

PostgreSQL 12 : Setting Up Streaming Replication

By Mouhamadou Diaw PostgreSQL 12 was released a few month ago. When actually setting up a replication, there is no longer recovery.conf file in the PGDATA. Indeed all parameters of the recovery.conf should be now in the postgresql.conf file. And(…)

Some words about SOUG Day in Lausanne

Today I participate to SOUG Day which takes place in Lausanne at the "Centre Pluriculturel et social d’Ouchy".

Handling PostgreSQL installations from packages

[vc_row type="in_container" full_screen_row_position="middle" scene_position="center" text_color="dark" text_align="left" overlay_strength="0.3" shape_divider_position="bottom" bg_image_animation="none"][vc_column column_padding="no-extra-padding" column_padding_position="all" background_color_opacity="1" background_hover_color_opacity="1" column_link_target="_self" column_shadow="none" column_border_radius="none" width="1/1" tablet_width_inherit="default" tablet_text_alignment="default" phone_text_alignment="default" column_border_width="none" column_border_style="solid" bg_image_animation="none"][vc_column_text]In this blog I will show how to handle a PostgreSQL installation with a customized PGDATA using the(…)

Patroni Operations – Changing Parameters

Sooner or later all of us have to change a parameter on the database. But how is this put into execution when using a Patroni cluster? Of course there are some specifics you have to consider. This post will give(…)

pgconf.eu – Welcome to the community

On tuesday I started my journey to Milan to attend my first pgconf.eu, which was also my first big conference. I was really excited what will come up to me. How will it be, to become a visible part of(…)