pg-partition-manager Open-Source Projects

• pg_partman

  7 1,873 7.3 PLpgSQL

  Partition management extension for PostgreSQL

  

Project mention: Dear data engineers | /r/dataengineering | 2023-12-06

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.

• 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.

  

pg-partition-manager related posts

• Dear data engineers
  1 project | /r/dataengineering | 6 Dec 2023
• 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
• Partitioning in Postgres, 2022 Edition
  1 project | news.ycombinator.com | 5 Oct 2022
• Table partitioning by months of the year?
  1 project | /r/PostgreSQL | 23 Aug 2021
• Replicating a dynamically partitioned table possible in Postgres 13
  1 project | /r/PostgreSQL | 8 Jan 2021
• 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 →

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com