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
Stars: 589
Forks: 69
Open issues: 52
License: other
Language: C
Size: 4.59 MB
Dependencies parsed at: Pending
Created at: over 9 years ago
Updated at: 29 days ago
Pushed at: 29 days ago
Last synced at: 29 days ago
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
Topics: customscan, fdw, hash, partition-table, partitioning, pathman, postgresql, query-optimization, range, runtimeappend
Version 1.5.2
1.5.2-4
- Partial support of declarative partitioning from PostgreSQL 10+.
- Compilation fixes for Windows.
Download
Download
Version 1.5
1.5.0
Improvements:
- Multilevel partitioning;
- Cross-partition updates (should be enabled with
pg_pathman.enable_partitionrouteroption), update triggers were removed; - Support for PostgreSQL 11;
- Rewritten from scratch cache subsystem;
- Stability-related fixes.
Other changes:
get_pathman_lib_version()was removed, usepathman_versioninstead;split_range_partitionwas optimized;merge_range_partitionsgets variable numbers of arguments instead of an array.
Download
Download
Version 1.4.13
1.4.13
- Enabled UPDATE/DELETE query optimization for partitions with dropped columns (issue #164);
- Fixed
SELECT * FROM partitioned_table ... UNION ALL ...in views (issue #165); - Fixed locking in
merge_range_partitions().
Download
Download
Version 1.4.11
1.4.11
- Fixed incorrect query results in case of (unsupported) multilevel partitioning (issue #155);
- Fixed spurious “table is being partitioned now” error raised by
partition_table_concurrently()(issue #153); - Relaxed check constraint handling (issue #137);
- Fixed builds on PostgreSQL 9.5.5 (issue #142);
- Fixed incorrect usage of memcpy() in start_bgworker();
1.4.10 has been used for a private build (Postgres Pro).
Download
Version 1.4.9
1.4.9
- Better integration with pg_shardman;
- Fixed handling of
ONLYin all kinds of quries (also fixes pg_repack, issue #134 );
Download
Version 1.4.8
1.4.8
- Improved cache invalidation machinery;
- Disabled
COPY partitioned_table TO. UseCOPY (SELECT * FROM partitioned_table) TOinstead.
After some discussion, we decided to disable COPY ... TO statement handling. This command will select rows only from parent table, which is good for pg_dump (see issue #50).
Download
Version 1.4.7
1.4.7
- Fixed INSTEAD OF triggers on views selecting from partitioned tables (issue #77);
ALTER TABLE partitioned_table RENAME TOnow also renames auto naming sequences (issue #127);- Disabled some dangerous optimizations for
SELECT ... FOR SHARE/UPDATEon PostgreSQL 9.5 (issue #129); - Improved error handling in concurrent partitioning background worker (aka ConcurrentPartWorker, more info);
Download