dev-db/pg_partman (defiance)

Search

Package Information

Description:
pg_partman is an extension to create and manage both time-based and serial-based table partition sets. Native partitioning in PostgreSQL 10 is supported as of pg_partman v3.0.1. Note that all the features of trigger-based partitioning are not yet supported in native, but performance in both reads and writes is significantly better. Child table creation is all managed by the extension itself. For non-native, trigger function maintenance is also handled. For non-native partitioning, tables with existing data can have their data partitioned in easily managed smaller batches. For native partitioning, the creation of a new partitioned set is required and data will have to be migrated over separately. Optional retention policy can automatically drop partitions no longer needed for both native and non-native partitioning. A background worker (BGW) process is included to automatically run partition maintenance without the need of an external scheduler (cron, etc) in most cases. All bug reports, feature requests and general questions can be directed to the Issues section on Github. Please feel free to post here no matter how minor you may feel your issue or question may be. - https://github.com/keithf4/pg_partman/issues If you're looking for a partitioning system that handles any range type beyond just time and serial, the new native partitioning features in PostgreSQL 10 are likely the best method for the foreseeable future. If this is something critical to your environment, start planning your upgrades now!
Homepage:
https://github.com/keithf4/pg_partman
License:
BSD

Versions

Version EAPI Keywords Slot
4.7.2 7 ~amd64 ~x86 0

Metadata

Description

Maintainers

Raw Metadata XML
<pkgmetadata>
	<maintainer type="person">
		<email>dan@d3fy.net</email>
		<name>Dan Molik</name>
	</maintainer>
	<longdescription lang="en">
		pg_partman is an extension to create and manage both time-based and serial-based table partition sets. Native partitioning in PostgreSQL 10 is supported as of pg_partman v3.0.1. Note that all the features of trigger-based partitioning are not yet supported in native, but performance in both reads and  writes is significantly better.

Child table creation is all managed by the extension itself. For non-native, trigger function maintenance is also handled. For non-native partitioning, tables with existing data can have their data partitioned in easily managed smaller batches. For native partitioning, the creation of a new partitioned set is required and data will have to be migrated over separately.

Optional retention policy can automatically drop partitions no longer needed for both native and non-native partitioning.

A background worker (BGW) process is included to automatically run partition maintenance without the need of an external scheduler (cron, etc) in most cases.

All bug reports, feature requests and general questions can be directed to the Issues section on Github. Please feel free to post here no matter how minor you may feel your issue or question may be. - https://github.com/keithf4/pg_partman/issues

If you're looking for a partitioning system that handles any range type beyond just time and serial, the new native partitioning features in PostgreSQL 10 are likely the best method for the foreseeable future. If this is something critical to your environment, start planning your upgrades now!
	</longdescription>
</pkgmetadata>

Lint Warnings

USE Flags

Flag Description 4.7.2
static-libs ⚠️

Manifest

Type File Size Versions
DIST pg_partman-4.7.2.tar.gz 1292622 bytes 4.7.2
Unmatched Entries
Type File Size