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

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

Releases
Version 1.5.2

1.5.2-4

  • Partial support of declarative partitioning from PostgreSQL 10+.
  • Compilation fixes for Windows.
about 7 years ago
Download
Version 1.5.1

1.5.1

Fixed compilation error on older gcc version (issue #177)

about 7 years ago
Download
Version 1.5

1.5.0

Improvements:

  • Multilevel partitioning;
  • Cross-partition updates (should be enabled with pg_pathman.enable_partitionrouter option), update triggers were removed;
  • Support for PostgreSQL 11;
  • Rewritten from scratch cache subsystem;
  • Stability-related fixes.

Other changes:

  • get_pathman_lib_version() was removed, use pathman_version instead;
  • split_range_partition was optimized;
  • merge_range_partitions gets variable numbers of arguments instead of an array.
about 7 years ago
Download
Version 1.4.14

1.4.14

Fixed cache invalidation errors leading to segfault

about 7 years ago
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().
over 7 years ago
Download
Version 1.4.12

1.4.12

Minor compatibility fixes for PostgreSQL 10.4, 9.6.9, 9.5.13.

over 7 years ago
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).

over 7 years ago
Download
Version 1.4.9

1.4.9

  • Better integration with pg_shardman;
  • Fixed handling of ONLY in all kinds of quries (also fixes pg_repack, issue #134 );
almost 8 years ago
Download
Version 1.4.8

1.4.8

  • Improved cache invalidation machinery;
  • Disabled COPY partitioned_table TO. Use COPY (SELECT * FROM partitioned_table) TO instead.

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).

about 8 years ago
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 TO now also renames auto naming sequences (issue #127);
  • Disabled some dangerous optimizations for SELECT ... FOR SHARE/UPDATE on PostgreSQL 9.5 (issue #129);
  • Improved error handling in concurrent partitioning background worker (aka ConcurrentPartWorker, more info);
about 8 years ago
Download