* Replace INSERT triggers with a custom node (aka**PartitionFilter**)

* Implement concurrent partitioning (much more responsive)

* Implement HASH-patitioning for non-integer attributes

* Implement[concurrent partitioning](https://github.com/postgrespro/pg_pathman/tree/concurrent_part) (much more responsive)

* Implement HASH partitioning for non-integer attributes

* Optimize hash join (both tables are partitioned by join key)

* Implement LISTpatitioning scheme

* Implement LISTpartitioning scheme

To install`pg_pathman`, execute this in the module's directory:

Modify the**`shared_preload_libraries`** parameter in`postgres.conf` as following:

Modify the**`shared_preload_libraries`** parameter in`postgresql.conf` as following:

Performs HASH partitioning for`relation` by integer key`attribute`. Creates`partitions_count` partitions and trigger on INSERT. All the data will be automatically copied from the parent to partitions.

create_range_partitions(relationTEXT,

attributeTEXT,

start_value ANYELEMENT,

Same as above, but for a RANGE-partitioned table.

split_range_partition(partitionTEXT, value ANYELEMENT)

Split RANGE`partition` in two by`value`.

merge_range_partitions(partition1TEXT, partition2TEXT)

Merge two adjacent RANGE partitions. First, data from`partition2` is copied to`partition1`, then`partition2` is removed.

append_range_partition(p_relationTEXT)

Append new RANGE partition.

prepend_range_partition(p_relationTEXT)

Prepend new RANGE partition.

add_range_partition(relationTEXT,

start_value ANYELEMENT,

end_value ANYELEMENT)

Create new RANGE partition for`relation` with specified range bounds.

drop_range_partition(partitionTEXT)

Drop RANGE partition and all its data.

attach_range_partition(relationTEXT,

partitionTEXT,

start_value ANYELEMENT,

end_value ANYELEMENT)

Attach partition to the existing RANGE-partitioned relation. The attached table must have exactly the same structure as the parent table, including the dropped columns.

detach_range_partition(partitionTEXT)

Detach partition from the existing RANGE-partitioned relation.

disable_partitioning(relationTEXT)

Permanently disable`pg_pathman` partitioning mechanism for the specified parent table and remove the insert trigger if it exists. All partitions and data remain unchanged.