reorg / pg_reorg Public Notifications Fork 5 Star 13 Code Issues 8 Pull requests Actions Projects Wiki Security Insights Issues: reorg/pg_reorgLabels 7 Milestones 1 New issue 8 Open 16 Closed Author Label Projects Milestones Assignee Sort Issues listDocument exit status codes in wiki ...
pg_repack was initially released as a drop-in replacement for pg_reorg, addressing some of the shortcomings of the last pg_reorg version (such as support for PostgreSQL 9.2 and EXTENSION packaging) and known bugs. pg_repack 1.2 introduces further new features (parallel index builds, ability to...
Hi, I used to use pg_reorg with PG 9.3. After our project migrated to PG 9.5.2 we decided to switch to pg_repack. We are using pg_repack 1.3.3 and we discovered that there are two big tables log_17322 and table_17322 in our database in s...
pg_repackもしくはpg_reorgの古いバージョンからのアップグレードを行うには、古いバージョンをデータベースから上記の手順で削除し、新しいバージョンを登録します。 利用方法 pg_repack [OPTION]... [DBNAME] OPTIONには以下のものが指定できます。
When I tried to repack my bloated table an error occurred: FATAL: terminating connection due to idle-in-transaction timeout ERROR: query failed: SSL connection has been closed unexpectedly DETAIL: query was: SAVEPOINT repack_sp1 and this...
Possibly related to #222 Today, I was trying to repack a table and I got the following warning: ERROR: query failed: FATAL: terminating connection due to idle-in-transaction timeout. As I had an idle_in_transaction_session_timeout of "ju...
pg_repack/bin/pg_repack.c Line 38 in 923fa2f #include <sys/poll.h> In file included from pg_repack.c:38:0: /usr/include/sys/poll.h:1:2: warning: #warning redirecting incorrect #include <sys/poll.h> to <poll.h> [-Wcpp] #warning redirecting incorrect #include <sys/poll.h>...
pg_repackcleans up triggers and other temporary objects. That error might be raised by a trigger created bypg_repack. Maybepg_repackdidn't finish successfully. You can check if there are any temporary relations by the command\dt repack.*and if there are any leftover triggers by the command...
Replace string concatenation to make dynamic queries by format() function Use fully qualified table names to select catalog tables (add pg_catalog)za-arthur added the enhancement label Oct 24, 2023 za-arthur mentioned this issue Oct 24, 2023 Move INSERT query of repack.repack_trigger to C ...
static bool lock_exclusive(PGconn *conn, const char *relid, const char *lock_query, bool start_xact, const repack_table *apply_log_table); static bool kill_ddl(PGconn *conn, Oid relid, bool terminate); static bool lock_access_share(PGconn *conn, Oid relid, const char *target_name);...