CHANGES.md

1.4.0 - Postgres 11+ feature support and enhancements

Full Postgres 11 feature support has been added with complete backward compatibility

• When starting a fresh project with Postgres 11 or higher, you can disable template tables and enable primary key constraints on partitioned tables:
  • config.create_template_tables now governs whether template tables are created by default (defaults true).
  • config.create_with_primary_key passed down primary key options to CREATE TABLE, including support for composite primary keys
• create_hash_partition, create_hash_partition_of, and attach_hash_partition methods provide support for Hash partitions
• create_default_partition_of and attach_default_partition allows adding of default partitions to range and list partitioned tables

Full support for Subpartitioning

• create_x_partition_of methods now support partition_type and partition_key, which may be supplied to create a partitioned child table.
  • Use create_x_partition_of with the child table name to add a partition to your subpartition
  • Template tables are supported in that nested subpartitions will inherit from the top-level ancestor's template table, if found
• The partitions command now accepts an include_subpartitions: option which defaults to false for backward compatibility
  • Use config.include_subpartitions_in_partition_list = true to override the default

add_index_on_all_partitions

• Use this new adapter method in migrations to add an index on all partitions and subpartitions automatically
• This method supports algorithm: :concurrently to perform uptime operations, so even when using Postgres 11+ it is needed to avoid table locks.
• If you have many partitions, use the optional in_threads: option to parallelize index creation via the parallel gem

Minor enhancements

• Added adapter methods partitions_for_table_name, parent_for_table_name, and table_partitioned? to assist automating partition management, especially where subpartitions are involved