Skip to content

Releases: postgrespro/pg_pathman

Version 1.5.2

04 Oct 17:05
Compare
Choose a tag to compare
  • Partial support of declarative partitioning from PostgreSQL 10+.
  • Compilation fixes for Windows.

Version 1.5.1

25 Sep 20:07
Compare
Choose a tag to compare

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

Version 1.5

24 Sep 14:05
Compare
Choose a tag to compare

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.

Version 1.4.14

13 Sep 15:23
Compare
Choose a tag to compare

Fixed cache invalidation errors leading to segfault

Version 1.4.13

10 Jul 10:54
Compare
Choose a tag to compare
  • 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().

Version 1.4.12

14 May 12:15
Compare
Choose a tag to compare

Minor compatibility fixes for PostgreSQL 10.4, 9.6.9, 9.5.13.

Version 1.4.11

27 Apr 14:20
Compare
Choose a tag to compare
  • 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).

Version 1.4.9

07 Dec 11:18
Compare
Choose a tag to compare
  • Better integration with pg_shardman;
  • Fixed handling of ONLY in all kinds of quries (also fixes pg_repack, issue #134 );

Version 1.4.8

03 Nov 10:44
Compare
Choose a tag to compare
  • 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).

Version 1.4.7

13 Oct 12:12
Compare
Choose a tag to compare
  • 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);