How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023, updated on May 10, 2023 by Yannick JaquierTable of contents Preamble Preparation of the test environment The old legacy technique The alter table switch technique The view technique The synonym technique The schema transfer technique Conclusion References Continue reading
Citus columnar storage hands-on Posted on March 28, 2023, updated on March 28, 2023 by Yannick JaquierTable of contents Preamble Citus installation Citus columnar storage testing preparation Citus columnar storage testing results References Continue reading
PostgreSQL logical replication hands-on Posted on September 1, 2022, updated on August 30, 2022 by Yannick JaquierTable of contents Preamble PostgreSQL configuration PostgreSQL logical replication configuration and testing PostgreSQL logical replication monitoring References Continue reading
PostgreSQL physical replication hands-on Posted on August 2, 2022, updated on August 2, 2022 by Yannick JaquierTable of contents Preamble Primary server setup Standby server setup for physical replication Without streaming replication With streaming replication Replication slots for physical replication Promoting a standby node Physical replication monitoring All in one pg_basebackup remote command References Continue reading
PostgreSQL graphical monitoring tools comparison Posted on August 28, 2021, updated on May 8, 2023 by Yannick JaquierTable of contents Preamble pgAdmin Postgres Enterprise Manager Postgres Enterprise Manager Server Postgres Enterprise Manager Agent OmniDB Percona Monitoring and Management Server Client PGWatch To be continued... References Continue reading
PostgreSQL backup and restore tools comparison for PITR recovery Posted on July 28, 2021, updated on August 2, 2021 by Yannick JaquierTable of contents PostgreSQL backup and restore Pg_basebackup PgBackRest EDB Backup and Recovery Tool Barman To be continued... References Continue reading