Ron Desjardins

  • Total activity 9
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 0

Activity overview

Latest activity by Ron Desjardins
  • Ron Desjardins created an article,

    Upgrade EPAS BigAnimal Cluster with Logical replication

    This article lists the prerequisites, restrictions, and a number of doable steps for upgrading an EPAS BigAnimal cluster to a new version utilizing logical replication.In this article, the older cl...

  • Ron Desjardins created an article,

    UTL_HTTP ports open with Oracle compatibility version

    Description The BigAnimal Oracle compatibility version offers the UTL_HTTP module as part of the Oracle compatibility feature. UTL_HTTP lets you connect through the HTTP protocol to a remote server...

  • Ron Desjardins created an article,

    How to handle "canceling statement due to conflict with recovery" error in BigAnimal

      Problem Description This error may happen in a read replica when, after initiating a select, some necessary rows for the select have been modified or deleted on the primary and the primary is vac...

  • Ron Desjardins created an article,

    BigAnimal logical replication on HA clusters limitation

    Problem Description BigAnimal offers a complete High Availability(HA) cluster in the cloud managed by EDB.Some customers may need to establish logical replication between the BigAnimal HA cluster a...

  • Ron Desjardins created an article,

    How to monitor disk space on BigAnimal PostgreSQL clusters

    Problem Description Disk space can grow very fast in some specific situations and, therefore, we need to constantly monitor the total occupation of the Postgres cluster volume in order to prevent a...

  • Ron Desjardins created an article,

    Running PGBench & PGCollector on BigAnimal

    Pgbench is a simple program for running benchmark tests on PostgreSQL. It runs the same sequence of SQL commands over and over, possibly in multiple concurrent database sessions, and then calculate...

  • Ron Desjardins created an article,

    DRITA create snapshot permission error

    Problem Description DRITA (Dynamic Runtime Instrumentation Tools Architecture) is a valid instrument to analyse and tune your cluster performance.It works taking statistical snapshots and comparing...

  • Ron Desjardins created an article,

    Database Activity and Locks

    Problem description Database users access and modify shared objects and data during normal activity.Relation databases handle these concurrent accesses and modifications using locks.PostgreSQL ha...

  • Ron Desjardins created an article,

    Debugging Performance Issues

    Problem Description Generally speaking, solving performance issues means finding a significant bottleneck which may cause the slowness of the database and removing it.This implies the use of tools...