{"repo":"pgpartman/pg_partman","free":true,"listed":false,"github":"https://github.com/pgpartman/pg_partman","clone":"git clone https://github.com/pgpartman/pg_partman.git","description":"Partition management extension for PostgreSQL","language":"PLpgSQL","stars":2793,"topics":["partitioning","plpgsql","pg-partition-manager","background-worker","postgresql","postgresql-extension"],"license":null,"category":"databases-storage","readme_excerpt":"PostgreSQL Partition Manager ==================== pg partman is an extension to create and manage both time-based and number-based table partition sets. As of version 5.0.1, only built-in, declarative partitioning is supported and the older trigger-based methods have been deprecated. The declarative partitioning built into PostgreSQL provides the commands to create a partitioned table and its children. pg partman uses the built-in declarative features that PostgreSQL provides and builds upon those with additional features and enhancements to make managing partitions easier. One key way that pg partman extends partitioning in Postgres is by providing a means to automate the child table maintenance over time (Ex. adding new children, dropping old ones based on a retention policy). pg partman also has features to turn an existing table into a partitioned table or vice versa. A background worker (BGW) process is included to automatically run partition maintenance without the need of an external scheduler (cron, etc) in most cases. Bug reports & feature requests can be directed to the Issues section on Github - For questions, comments, or if you're just not sure where to post, please use the Discussions section on Github. Feel free to post here no matter how minor you may feel your issue or question may be - DOCUMENTATION ------------- The following list of files is found in the doc folder of the pg partman github repository. For installation instructions, please see the next sect","default_branch":null,"files":null,"tree":[],"storefront":"/r/pgpartman","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pgpartman/pg_partman/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."}