Reorganize tables in PostgreSQL databases with minimal locks

文件	最后提交记录	最后更新时间
.github	add postgresql 19 to test matrix No significant code changes are required.	4 个月前
bin	fix compiler warning pg_repack.c: In function ‘check_tablespace’: pg_repack.c:447:1: warning: old-style function definition [-Wold-style-definition] postgresql 19 uses more strict compiler option	4 个月前
doc	update supported version number in docs	4 个月前
lib	Acquire ACCESS EXCLUSIVE lock on repack_drop() when trigger exists repack_swap() already drops the trigger repack_trigger and repack_drop() doesn't need to drop it if repack_swap() finished successfully. If repack_drop() doesn't need to drop the trigger it also doesn't need to acquire ACCESS EXCLUSIVE lock which might be beneficial on write heavy tables.	8 个月前
msvc	Dropped executable flags	13 年前
regress	pg_repack is aborted with error if a publication FOR ALL TABLES exists and apply_log requires deleting or updating a row in a temporary table. ERROR: cannot update table "table_16388" because it does not have a replica identity and publishes updates It's not that difficult to format `ALTER TABLE repack.table_' \|\| R.oid \|\| ' REPLICA IDENTITY USING INDEX index_' \|\| PK.indexrelid` in repack.tables, but for this to work, I also need to set NOT NULL on columns, which is less trivial. Furthermore, repack might break subscribers of this publication. Given the lack of previous bug reports (this setup never worked since introduction of publications in pg10), I suggest adding a FOR ALL TABLES check for publications and simply refusing to work in such a database by default.	5 个月前
.gitignore	Issue #420: Acquire SHARE UPDATE EXCLUSIVE by conn2 (#452) Currently conn2 acquires ACCESS SHARE lock which allows to run concurrent DDL statements, like CREATE INDEX CONCURRENTLY. Fix it by acquiring SHARE UPDATE EXCLUSIVE lock. This will also lock concurrent VACUUM, ANALYZE queries, locking them looks safer option anyway.	1 年前
COPYRIGHT	Copyright year bumped	5 年前
META.json	Release notes for 1.5.3	10 个月前
Makefile	Copyright year bumped	5 年前
README.rst	Update README.rst CI badge. (#353)	3 年前