{"repo":"postgrespro/pg_pathman","free":true,"listed":false,"github":"https://github.com/postgrespro/pg_pathman","clone":"git clone https://github.com/postgrespro/pg_pathman.git","description":"Partitioning tool for PostgreSQL","language":"C","stars":586,"topics":["postgresql","range","hash","fdw","partition-table","partitioning","pathman","query-optimization","runtimeappend","customscan"],"license":null,"category":"databases-storage","readme_excerpt":"NOTE: this project is not under development anymore pg pathman supports Postgres versions [11..15], but most probably it won't be ported to later releases. Native partitioning is pretty mature now and has almost everything implemented in pg pathman '; we encourage users switching to it. We are still maintaining the project (fixing bugs in supported versions), but no new development is going to happen here. pg pathman The pg pathman module provides optimized partitioning mechanism and functions to manage partitions. The extension is compatible with: PostgreSQL 12, 13; PostgreSQL with core-patch: 11, 14, 15; Postgres Pro Standard 11, 12, 13, 14, 15; Postgres Pro Enterprise; Take a look at our Wiki out there. Overview Partitioning means splitting one large table into smaller pieces. Each row in such table is moved to a single partition according to the partitioning key. PostgreSQL , =), CONST is a scalar value. For example: Based on the partitioning type and condition's operator, pg pathman searches for the corresponding partitions and builds the plan. Currently pg pathman supports two partitioning schemes: RANGE - maps rows to partitions using partitioning key ranges assigned to each partition. Optimization is achieved by using the binary search algorithm; HASH - maps rows to partitions using a generic hash function. More interesting features are yet to come. Stay tuned! Feature highlights HASH and RANGE partitioning schemes; Partitioning by expression and composite key; Both a","default_branch":null,"files":null,"tree":[],"storefront":"/r/postgrespro","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/postgrespro/pg_pathman/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}