Tag: postgresql

Part 1- Deploy GoldenGate 23c Free and two Oracle Database 23.3 on Docker in just a few Minutes

Part 1- Deploy GoldenGate 23c Free and two Oracle Database 23.3 on Docker in just a few Minutes

Introduction: This Part 1 post will show you how to create a GoldenGate Free 23.3 (Hub) that connects to two Oracle Database Free 23.3 (I am calling them West and East). This is extremely easy if we take advantage of containers as I will describe it below. Part 2 will demonstrate how to automate the creation … Continue reading Part 1- Deploy GoldenGate 23c Free and two Oracle Database 23.3 on Docker in just a few Minutes

How to find total size of partition table and its indexes on Postgresql?

How to find total size of partition table and its indexes on Postgresql?

select pg_size_pretty(sum(pg_total_relation_size(inhrelid::regclass))) from pg_inherits where inhparent='<schema>.<table>'::regclass; pg_size_pretty ---------------- 4410 GB