pg_partman
practical-sql
pg_partman | practical-sql | |
---|---|---|
7 | 1 | |
1,879 | 624 | |
2.4% | - | |
7.0 | 0.0 | |
23 days ago | over 1 year ago | |
PLpgSQL | PLpgSQL | |
GNU General Public License v3.0 or later | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pg_partman
-
Dear data engineers
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
-
Which is the best way to automate backing up data monthly of tables in a schema and then deleting them?
pg_partman is in RDS >12.5 (here). Pg_partman makes managing data retention relatively easy.
- Partitioning in Postgres, 2022 Edition
-
TimescaleDB 2.7 vs. PostgreSQL 14
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?
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
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.
practical-sql
-
Having trouble with INNER JOIN
(The tables I'm using for data are on GitHub here, in chapter 4 for the 2010 data and chapter 6 for the 2000 data.)
What are some alternatives?
periods - PERIODs and SYSTEM VERSIONING for PostgreSQL
helium-etl-queries - A collection of SQL views used to enrich data produced by a Helium blockchain-etl
pgddl - DDL eXtractor functions for PostgreSQL (ddlx)
pgstac - Schema, functions and a python library for storing and accessing STAC collections and items in PostgreSQL
blog - OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog
postgres-aws-s3 - aws_s3 postgres extension to import/export data from/to s3 (compatible with aws_s3 extension on AWS RDS)
metagration - Metagration: PostgreSQL Migrator in PostgreSQL
zombodb - Making Postgres and Elasticsearch work together like it's 2023
omdb-postgresql - PostgreSQL Schema for OMDB
Milvus - A cloud-native vector database, storage for next generation AI applications
parquet_s3_fdw - ParquetS3 Foreign Data Wrapper for PostgresSQL
aquameta - Web development platform built entirely in PostgreSQL