GitHub / postgrespro / pg_pathman
Partitioning tool for PostgreSQL
JSON API: http://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/postgrespro%2Fpg_pathman
PURL: pkg:github/postgrespro/pg_pathman
étoiles: 589
forks: 69
issues ouvertes: 52
licence: other
langage: C
taille: 4,59 Mo
dépendances analysées: En attente
date de création: il y a plus de 9 ans
date de mise à jour: il y a 29 jours
enregistré: il y a 29 jours
dernière synchronisation: il y a 29 jours
Commit Stats
Commits: 1479
Authors: 28
Mean commits per author: 52.82
Development Distribution Score: 0.44
More commit stats: https://commits.ecosyste.ms/hosts/GitHub/repositories/postgrespro/pg_pathman
Sujets: customscan, fdw, hash, partition-table, partitioning, pathman, postgresql, query-optimization, range, runtimeappend
Version 1.2.1
1.2.1
Minor fixes and improvements:
- Fixed function
choose_range_partition_name()for 32-bit platforms; - Removed BOM marks (caused broken builds on old compilers).
Download
Version 1.2
1.2
- Parallel SeqScan support;
- Re-implemented some of
plpgsqlfunctions in C; - Implemented auto check constraints renaming for partitions;
- Added
replace_hash_partition()function; SpawnPartitionsWorkeris disabled by default (can be enabled withset_spawn_using_bgw()function);- Improved planning process (fixed bugs with inlined SQL functions, stability fixes);
- Auto created partitions share the same owner. (parent table owner);
- Partition creation now requires
INSERTpermission on parent table.
Download
Version 1.1.1
1.1.1
- Fixed not working
attach_range_partition()andadd_range_partition()when relation is marked as ‘partitioned’ (viapathman_config) but has no children; - Prevent
pathman_process_utility_hook()from messing with other extensions, e.g.pg_stat_statements(issue #42); - Enable partition creation for
COPY FROMstatement (can be switched off); - Minor improvements and stability fixes.
Download
Version 1.1
1.1
New features and enhancements:
- PostgreSQL 9.6 support;
- Tablespace support (#11);
COPY FROM/TOsupport for partitioned tables (only for UNIX-like systems);- Improved FDW support (redirect inserted rows);
- User-defined callbacks on partition creation events (#22);
- Permissions improvements (owner can manage his partitions without being superuser);
- Fixed
SELECT FOR SHARE / FOR UPDATEhandling; - Fixed
SELECT ... WHERE partitioned_attribute IN (...)for RANGE partitioning; - Fixed unique inner & outer nested loop plan generation (sometimes there would be unwanted extra rows);
- Improved pl/PgSQL API (stability & performance, #39);
- Improved RANGE partitioning for domains and some other types.
Download
Version 1.0.1
1.0.1
Fix wrong check constraint naming (function build_check_constraint_name_internal()).
Download
Early prototype
0.1 Pre-release
The prototype features RuntimeAppend & RuntimeMergeAppend custom nodes capable of discarding useless partition scans dynamically at runtime. This version is now deprecated.
Download
Release candidate #1
1.0_rc1 Pre-release
This release contains various bugfixes and improvements, such as reworked partitioning info cache, concurrent partitioning and PartitionFilter custom node (drop-in replacement for INSERT triggers).
Download