Crunchy Data

OpenStreetMap friends might be interested in this blog post today. Full planet load into the database in less than 4 hours. https://www.crunchydata.com/blog/loading-the-world-openstreetmap-import-in-under-4-hours

https://www.crunchydata.com/blog/huge-pages-and-postgres-in-containers
We love it when we get to work with the open source community! We recently helped with patches to OCI and Postgres 16 to make huge pages work with Postgres in containers and Kubernetes.

Huge Pages and Postgres in Containers We love it when we get to work with the open source community! We recently helped with patches to OCI and Postgres 16 to make huge pages work with Postgres in containers and Kubernetes.

Partitioning is a handy tool for managing size and performance as your database scales. Elizabeth offers a tutorial of native partitioning and pg_partman using a sample IoT dataset. This tutorial contains the sql and steps for you to try out partitioning yourself with Postgres.

Partitioning with Native Postgres and pg_partman