pg_pathman is a PostgreSQL extension that provides high-performance partitioning support, developed by PostgresPro. It improves query planning and execution speed for partitioned tables by introducing advanced partition pruning and runtime optimization strategies. It’s ideal for large datasets that require fine-tuned partition control.

Features

  • Automatic or manual table partitioning in Postgres
  • Supports range and hash partitioning methods
  • Query planner optimizations for fast partition pruning
  • Background worker for partition maintenance
  • Integration with native PostgreSQL partitioning features
  • Reduced planning and execution time for large queries

Project Samples

pg_pathman Screenshot 1 pg_pathman Screenshot 2

Project Activity

See All Activity >

Categories

Database

License

MIT License

Follow pg_pathman

pg_pathman Web Site

Other Useful Business Software
8 Monitoring Tools in One APM. Install in 5 Minutes. Icon
8 Monitoring Tools in One APM. Install in 5 Minutes.

Errors, performance, logs, uptime, hosts, anomalies, dashboards, and check-ins. One interface.

AppSignal works out of the box for Ruby, Elixir, Node.js, Python, and more. 30-day free trial, no credit card required.
Start Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of pg_pathman!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

C

Related Categories

C Database Software

Registered

2025-06-17
Report inappropriate content