Bertrand Drouvot
Database engineer at Amazon Web Services
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.
Upcoming presentations
No upcoming presentations...
Past presentations
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...
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....