range_partitioning 1.2.2
- This Release
- range_partitioning 1.2.2
- Date
- Status
- Stable
- Latest Unstable
- range_partitioning 0.0.1 —
- Other Releases
- Abstract
- Partition a table by static ranges
- Description
- Convert ordinary tables into partitioned tables based on an arbitrary column. Add partitions by splitting an existing partition into two adjacent sub-ranges. Combine two adjacent partitions into a single partition.
- Released By
- chuinker
- License
- PostgreSQL
- Resources
- Special Files
Extensions
- range_partitioning 1.2.2
- Partition a table by static ranges
Documentation
- LICENSE
- Copyright and License
README
Contents
Range Partitioning
Create and manage tables which will be partitioned by static ranges. The partitioning column can be any type for which there is a corresponding range type, even if that range type was user-created.
USAGE
For function documentation and examples, see the range_partitioning.md file.
INSTALLATION
Requirements: PostgreSQL 9.2 or greater.
In the directory where you downloaded range_partitioning, run
bash
make install
Log into PostgreSQL.
sql
CREATE EXTENSION range_partitioning;
or
sql
CREATE EXTENSION range_partitioning SCHEMA my_schema;
A role named range_partitioning is created. Grant that role to any user who needs to create or remove partitions.
UPGRADE
Run "make install" same as above to put the script files and libraries in place. Then run the following in PostgreSQL itself:
sql
ALTER EXTENSION range_partitioning UPDATE TO '<latest version>';