Hacker GitHub

← All repos

pgpartman/pg_partman

View on GitHub ↗ ★ 2,848 PLpgSQL

Partition management extension for PostgreSQL

14 mentions on Hacker News by 12 people: 2 stories, 12 comments · first 2015-07-23 · latest 2026-08-08

Mentions per year 14 mentions · busiest year 2016 (3)
20082026
AllStoriesComments NewestTopOldest
  1. …drop entire partitions over time. [0] https://www.mongodb.com/docs/manual/core/index-ttl/ [1] https://github.com/pgpartman/pg_partman
    comment by hasyimibhar · 2026-08-08 · in Making Postgres 300x faster for analytics: batching, operator fusion, and SIMD
  2. TIL about pg_partman https://github.com/pgpartman/pg_partman/blob/development/doc...
    comment by aftbit · 2026-06-14 · in The only scalable delete in Postgres is DROP TABLE
  3. …which is included in most distributions of Postgres (including RDS) can handle some cases - https://github.com/pgpartman/pg_partman - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Postg...
    comment by yawgmoth · 2022-10-05 · in Partitioning in Postgres, 2022 Edition
  4. …its (seemingly) purposeful omission in these, otherwise very thorough blog posts, misleading. [0] https://github.com/pgpartman/pg_partman/blob/master/doc/pg_p...
    comment by boomskats · 2022-09-22 · in TimescaleDB 2.7 vs. PostgreSQL 14
  5. …). Rich data types aren't the only candidates for extensions, automated partition management ( https://github.com/pgpartman/pg_partman ), data sharding ( https://www.citusdata.com/ ), or even database cron scheduling (…
    comment by gshulegaard · 2020-07-13 · in PGX: Write Postgres extensions in Rust instead of C
  6. …www.postgresql.org/docs/12/ddl-inherit.html ) * PGPartman for automating the creation of partitions ( https://github.com/pgpartman/pg_partman ) * Citus for low-barrier data sharding (it's a Postgres Extension like PostGIS) (…
    comment by gshulegaard · 2020-07-11 · in Making Netflix's Data Infrastructure Cost-Effective
  7. …awesome and does the same job. [0] https://github.com/timescale/timescaledb/blob/master/LICENSE [1] https://github.com/pgpartman/pg_partman
    comment by boomskats · 2019-05-07 · in Zabbix, Time Series Data and TimescaleDB
  8. …parent and child tables, automated partitioning and the user only queries the parent tables. https://github.com/keithf4/pg_partman
    comment by Tommek · 2017-04-04 · in Building a scalable time-series database on PostgreSQL
  9. Ummm https://github.com/keithf4/pg_partman has been around for a long time and is used all around the world... AND it doesn't require cron jobs. Much tighter solution
    comment by postwait · 2016-09-21 · in Pgslice: Postgres partitioning as easy as pie
  10. …(2009?). It worked quite well and is still in use today. Since then have also used the referenced https://github.com/keithf4/pg_partman on RDS - and it works great! Very happy to have all the partition management in the core database vs.…
    comment by michaelbryzek · 2016-09-21 · in Pgslice: Postgres partitioning as easy as pie
  11. …a PG extension. Also, how does it compare with pg_partman[1] which also has similar goals? [1] https://github.com/keithf4/pg_partman
    comment by takeda · 2016-09-21 · in Pgslice: Postgres partitioning as easy as pie
  12. …be vacuumed with VACUUM FREEZE, or deleted later. There are extensions to help make that easier. https://github.com/keithf4/pg_partman Josh Berkus of PgExperts has some great advice here: https://dba.stackexchange.com/questions/21068/aggres…
    comment by Kassandry · 2015-07-23 · in Transaction ID Wraparound in Postgres