Differences

This shows you the differences between two versions of the page.

--- postgresqlextensions [2024/03/01 15:21] – z0hpvk
+++ postgresqlextensions [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ===== PostgreSQL Extensions =====
-==== PG_CRON ====
+==== pg_cron ====
 [[https://github.com/citusdata/pg_cron/]]\\
@@ Line 36: / Line 36: @@
 </code>
-==== PGLOGICAL ====
+==== pglogical ====
 [[https://www.2ndquadrant.com/en/resources/pglogical/]]
@@ Line 44: / Line 44: @@
 </code>
-==== PGBOUNCER ====
+==== pgbouncer ====
 [[https://www.pgbouncer.org/config.html]]\\
 <code>
@@ Line 59: / Line 59: @@
 RELOAD;
 </code>
-==== PG_STAT_STATEMENTS ====
+==== pg_stat_statements ====
 [[https://www.postgresql.org/docs/current/pgstatstatements.html]]
@@ Line 71: / Line 71: @@
 </code>
-==== POSTGIS ====
+==== postgis ====
 [[https://postgis.net/]]
 <code>
@@ Line 80: / Line 80: @@
 </code>
-==== POSTGRES_FDW ====
+==== postgres_fdw ====
 [[https://www.postgresql.org/docs/current/postgres-fdw.html]]
-==== PG_BUFFERCACHE ====
+==== pg_buffercache ====
 [[https://www.postgresql.org/docs/current/pgbuffercache.html]]
 <code>
@@ Line 106: / Line 106: @@
 </code>
-==== PGBADGER ====
+==== pgbadger ====
 [[https://pgbadger.darold.net/]]\\
@@ Line 136: / Line 136: @@
 </code>
 [[PGBadgerReports| PGBadger Reports]]\\
+==== pg_repack ====
+=== AWS Instructions ===
+https://aws.amazon.com/blogs/database/remove-bloat-from-amazon-aurora-and-rds-for-postgresql-with-pg_repack/
+=== Download ===
+For PostgreSQL 14 on AWS, use version 1.4.7. \\
+https://pgxn.org/dist/pg_repack/1.4.7/
+=== Installation ===
+https://reorg.github.io/pg_repack/#installation
+<code bash>
+sudo apt install postgresql-server-dev-12 gcc zlib1g-dev
+unzip pg_repack-1.4.5.zip
+cd pg_repack-1.4.5
+make
+sudo make install
+</code>
+<code postgresql>
+CREATE EXTENSION pg_repack;
+</code>
+=== Usage ===
+pg_repack will attempt to get an exclusive lock on the table being re-organised. \\
+If it can’t then, by default, it will attempt to terminate any sessions that are blocking it. \\
+Use option ''--no-kill-backend (-D)'' to allow pg_repack to terminate if it can’t get a lock. \\
+<code bash>
+cd pg_repack-1.4.5/bin
+./pg_repack -k -h localhost -U postgres -D -t football.teams doob
+</code>