Pg_partman Alternatives

Similar projects and alternatives to pg_partman

Milvus

104 26,645 10.0 Go pg_partman VS Milvus

A cloud-native vector database, storage for next generation AI applications
TimescaleDB

82 16,445 9.8 C pg_partman VS TimescaleDB

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
WorkOS

workos.com sponsored

The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
ClickBench

68 567 9.1 HTML pg_partman VS ClickBench

ClickBench: a Benchmark For Analytical Databases
periods

5 235 2.4 PLpgSQL pg_partman VS periods

PERIODs and SYSTEM VERSIONING for PostgreSQL
pgddl

2 117 8.5 PLpgSQL pg_partman VS pgddl

DDL eXtractor functions for PostgreSQL (ddlx)
blog

1 7,814 9.9 PLpgSQL pg_partman VS blog

OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog (by digoal)
postgres-aws-s3

1 135 0.0 PLpgSQL pg_partman VS postgres-aws-s3

aws_s3 postgres extension to import/export data from/to s3 (compatible with aws_s3 extension on AWS RDS)
InfluxDB

www.influxdata.com sponsored

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
practical-sql

1 624 0.0 PLpgSQL pg_partman VS practical-sql

Code and Data for the First Edition of "Practical SQL" by Anthony DeBarros, published by No Starch Press (2018).
metagration

4 100 0.0 PLpgSQL pg_partman VS metagration

Metagration: PostgreSQL Migrator in PostgreSQL
zombodb

23 4,608 8.3 PLpgSQL pg_partman VS zombodb

Making Postgres and Elasticsearch work together like it's 2023
omdb-postgresql

1 39 4.0 PLpgSQL pg_partman VS omdb-postgresql

PostgreSQL Schema for OMDB
parquet_s3_fdw

1 159 2.3 PLpgSQL pg_partman VS parquet_s3_fdw

ParquetS3 Foreign Data Wrapper for PostgresSQL

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better pg_partman alternative or higher similarity.

Suggest an alternative to pg_partman

pg_partman reviews and mentions

Posts with mentions or reviews of pg_partman. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-09-22.

Dear data engineers
1 project | /r/dataengineering | 6 Dec 2023

Assuming these are the types of insights you're looking for, you'll probably look for a way to aggregate data points across/within geographies. postgis is an open source extension for postgres that can help you with this, but there's also quite a few python tools that can help you explore the data, such as geopandas, folium, geoplot. Depending on volume, you might want to partition the data for query performance, and there's another extension pg_partman that can help with that. Just noticed some other posts have recommended something similar.
Pgpartman: Partition Management Extension for Postgres
1 project | news.ycombinator.com | 20 Sep 2023
Which is the best way to automate backing up data monthly of tables in a schema and then deleting them?
1 project | /r/PostgreSQL | 6 Oct 2022

pg_partman is in RDS >12.5 (here). Pg_partman makes managing data retention relatively easy.
Partitioning in Postgres, 2022 Edition
1 project | news.ycombinator.com | 5 Oct 2022
TimescaleDB 2.7 vs. PostgreSQL 14
4 projects | news.ycombinator.com | 22 Sep 2022

Whenever I see these posts from TimescaleDB, I always want to ask them how it compares in performance to alternative extensions that implement the same features, rather than just comparing TimescaleDB to vanilla PostgreSQL.
For example, they mention their automated data retention and how it's achieved with one SQL command, and how DELETEing records is a very costly operation, and how "even if you were using Postgres declarative partitioning you’d still need to automate the process yourself, wasting precious developer time, adding additional requirements, and implementing bespoke code that needs to be supported moving forward".
There's zero mention anywhere of pg_partman, which does all of these things for you equally as simply, and is a fully OSS free alternative [0].
I get that it's a PG extension that competes with their product. I know that TimescaleDB does a few other things that pg_partman does not. But I can't help but find its (seemingly) purposeful omission in these, otherwise very thorough blog posts, misleading.
[0] https://github.com/pgpartman/pg_partman/blob/master/doc/pg_p...
Table partitioning by months of the year?
1 project | /r/PostgreSQL | 23 Aug 2021

Take a look into this extension which would take care of a good amount of automation for you.
Replicating a dynamically partitioned table possible in Postgres 13
1 project | /r/PostgreSQL | 8 Jan 2021

You might want to look into pg_partman which has many useful tools around semi-automatic partitioning. According to their documentation they already have a procedure that will do exactly that: create new partitions based on the rows in the default partition.
A note from our sponsor - WorkOS
workos.com | 24 Apr 2024

The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →