An open API service providing repository metadata for many open source software ecosystems.

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

Releases
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).
presque 9 ans ago
Download
Version 1.2

1.2

  • Parallel SeqScan support;
  • Re-implemented some of plpgsql functions in C;
  • Implemented auto check constraints renaming for partitions;
  • Added replace_hash_partition() function;
  • SpawnPartitionsWorker is disabled by default (can be enabled with set_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 INSERT permission on parent table.
presque 9 ans ago
Download
Version 1.1.1

1.1.1

  • Fixed not working attach_range_partition() and add_range_partition() when relation is marked as ‘partitioned’ (via pathman_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 FROM statement (can be switched off);
  • Minor improvements and stability fixes.
environ 9 ans ago
Download
Version 1.1

1.1

New features and enhancements:

  • PostgreSQL 9.6 support;
  • Tablespace support (#11);
  • COPY FROM/TO support 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 UPDATE handling;
  • 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.
environ 9 ans ago
Download
Version 1.0.1

1.0.1

Fix wrong check constraint naming (function build_check_constraint_name_internal()).

environ 9 ans ago
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.

environ 9 ans ago
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).

environ 9 ans ago
Download