./databases/pg_repack, Reorganize tables in PostgreSQL databases with minimal locks

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 1.5.1, Package name: postgresql13-pg_repack-1.5.1, Maintainer: pkgsrc-users

pg_repack is a PostgreSQL extension which lets you remove bloat from
tables and indexes, and optionally restore the physical order of
clustered indexes.


Required to run:
[databases/postgresql10-client]

Master sites:

Filesize: 97.325 KB

Version history: (Expand)

CVS history: (Expand)


   2024-09-23 10:15:58 by Adam Ciarcinski | Files touched by this commit (2) | Package updated
Log message:
pg_repack: updated to 1.5.1

pg_repack 1.5.1

Added support for PostgreSQL 17
Fix wrong OID format type in repack_trigger
Fix check of NOT NULL by repack.primary_keys
Fixed processing of tablespace names requiring quoted identifiers
Replace PQconnectdb() by PQconnectdbParams()
Added --apply-count option
Do not include a declaratively partitioned table with option --only-indexes
Fix possible two vacuums concurrently processing the same relfilenode
Use savepoints when retrying to take AccessShareLock
Fix swap of relfrozenxid, relfrozenxid and relallvisible
   2024-01-26 14:40:21 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
pg_repack: updated to 1.5.0

pg_repack 1.5.0

* Added support for PostgreSQL 16
* Fix possible SQL injection
* Support longer password length
* Fixed infinite loop on empty password
* Added ``--switch-threshold`` option
* Fixed crash in ``get_order_by()`` using invalid relations
* Added support for tables that have been previously rewritten with `VACUUM \ 
FULL` and use storage=plain for all columns
* More careful locks acquisition
   2023-03-03 11:51:11 by Adam Ciarcinski | Files touched by this commit (4) | Package updated
Log message:
pg_repack: updated to 1.4.8

1.4.8
* Added support for PostgreSQL 15
* Fixed --parent-table on declarative partitioned tables
* Removed connection info from error log

1.4.7
* Added support for PostgreSQL 14

1.4.6
* Added support for PostgreSQL 13
* Dropped support for PostgreSQL before 9.4

1.4.5
* Added support for PostgreSQL 12
* Fixed parallel processing for indexes with operators from public schema

1.4.4
* Added support for PostgreSQL 11
* Remove duplicate password prompt
   2022-04-25 08:25:43 by Thomas Klausner | Files touched by this commit (3) 
Log message:
*: remove some references to postgresql 9.6
   2021-10-26 12:10:08 by Nia Alarie | Files touched by this commit (417) 
Log message:
databases: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

The following distfiles could not be fetched (some may be only fetched
conditionally):

./databases/cstore/distinfo D6.data.ros.gz
./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz
   2021-10-07 15:35:53 by Nia Alarie | Files touched by this commit (417) 
Log message:
databases: Remove SHA1 distfile hashes
   2021-05-24 10:23:18 by Adam Ciarcinski | Files touched by this commit (4) 
Log message:
Adjust PGSQL_VERSIONS_ACCEPTED
   2020-06-02 00:17:34 by Joerg Sonnenberger | Files touched by this commit (1) 
Log message:
Remove unsupported PG version