About

Bertrand is an IT professional since about 20 years mainly focusing on databases and data. He currently works for Amazon Web Services (as a Database Engineer). He is an OakTable member, has been active in the Oracle community since 2012 and is a regular speaker in Europe conferences. He is currently having a lot of interest around open source and mainly PostgreSQL.


Bertrand Drouvot has presented the following presentations

    Bertrand Drouvot Mass databases migrations to PostgreSQL at scale: Complexity study and migration at Postgres Conference 2020

    presented by Bertrand Drouvot

    Do you want to migrate all or part of your oracle databases to PostgreSQL? How doable, difficult would it be? In this session you'll see how it is possible to prepare a mass databases migrations to PostgreSQL at scale. The complexity study will be done using free softwares (Ora2Pg, Schema Conversion Tool) and part of the AWS offering (cloudformation, autoscaling group, simple queue service, S3...

    more

    Migration
    Bertrand Drouvot Active Session History In PostgreSQL: Why?, How? and use cases at Postgres Conference 2020

    presented by Bertrand Drouvot

    PostgreSQL provides session activity. However, in order to gather activity behavior, users have to sample the pg_stat_activity view multiple times. Furthermore, it could be even more useful to link the session activity to the sql statistics (coming from pg_stat_statements): that would provide the ability to easily drill-down to the sqls activity from a general overview of the database activity....

    more

    Ops and Administration