Database Administration & Monitoring, Database management, PostgreSQL From Oracle to Postgres with the EDB Postgres Migration Portal 08.10.2018 by Joël Cattin EnterpriseDB is a valuable actor in PostgreSQL’s world. In addition to provide support, they also deliver very useful tools to manage easily your Postgres environments. Among these we can mention EDB Enterprise Manager, EDB Backup & Recovery Tool, EDB Failover(…)
PostgreSQL Masking Data With PostgreSQL 13.09.2018 by Oracle Team By Mouhamadou Diaw I was searching a tool for anonymizing data in a PostgreSQL database and I have tested the extension pg_anonymizer. PostgreSQL_anonymizer is a set of SQL functions that remove personally identifiable values from a(…)
Database Administration & Monitoring, PostgreSQL Drilling down the pgSentinel Active Session History 15.07.2018 by Oracle Team By Franck Pachot . In pgSentinel: the sampling approach for PostgreSQL I mentioned that one of the advantages of the ASH approach is the ability to drill down from an overview of the database activity,(…)
Database Administration & Monitoring, PostgreSQL pgSentinel: the sampling approach for PostgreSQL 12.07.2018 by Oracle Team 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(…)
Oracle, PostgreSQL PGIO, PG_STAT_ACTIVITY and PG_STAT_STATEMENTS 28.06.2018 by Oracle Team By Franck Pachot . For an Oracle DBA, we are used to join active sessions (from V$SESSION where status='ACTIVE) with active statements (from V$SQL where users_executing>0) on the SQL_ID. V$ACTIVE_SESSION_HISTORY also displays the TOP_LEVEL_SQL_ID to get the entrypoint of the(…)
Database Administration & Monitoring, PostgreSQL Lighty for PostgreSQL 27.06.2018 by Oracle Team By Franck Pachot . If you follow this blog, you should know how I like Orachrome Lighty for Oracle, for its efficiency to monitor database performance statistics. Today Orachrome released the beta version of Lighty for Postgres:(…)
Cloud, Oracle, PostgreSQL Which Bitnami service to choose in the Oracle Cloud Infrastructure? 25.05.2018 by Oracle Team By Franck Pachot . In the Oracle Cloud PaaS you have a marketplace where you can choose your service. Some are packaged from Bitnami and available on multiple OS. My first idea is that in PaaS you do not care(…)
PostgreSQL Postgres, the fsync() issue, and ‘pgio’ (the SLOB method for PostgreSQL) 24.05.2018 by Oracle Team 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(…)
Database Administration & Monitoring, Database management, PostgreSQL PostgreSQL – logical replication with pglogical 23.03.2018 by Joël Cattin Although PostgreSQL 10 integrate native logical replication (have a look here or here), it is always interesting to be aware of alternative solutions to the available in-core features. One of those is called(…)
Oracle, PostgreSQL Full page logging in Postgres and Oracle 14.02.2018 by Oracle Team By Franck Pachot . In my opinion, the volume of logging (aka redo log, aka xlog, aka WAL) is the most important factor for OLTP performance, availability and scalability, for several reasons: This is the only structure where disk latency(…)