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.

https://www.crunchydata.com/blog/remote-access-anything-from-postgres
ogr_fdw is a powerhouse of options for accessing data from within Postgres. Paul digs into samples with CSV, Excel from S3, and SQLite.

Remote Access Anything from Postgres ogr_fdw is a powerhouse of options for accessing data from within Postgres. Paul digs into samples with CSV, Excel from S3, and SQLite.

https://www.crunchydata.com/blog/introducing-database-insights-effortless-postgres-management-with-crunchy-bridge
Introducing Database Insights: Effortless Postgres Management with Crunchy Bridge

Introducing Database Insights: Effortless Postgres Management with Crunchy Bridge Crunchy Bridge now has database insights to keep track of key performance indicators for your Postgres database. From database tools like slow queries and cache hit ratio, to machine stats like CPU and IOPS, and a production check. We are making database management easier than ever.

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

https://blog.crunchydata.com/blog/streaming-replication-across-kubernetes-postgres-clusters

Streaming Replication Across Kubernetes Postgres Clusters A guide to setting up streaming replication between two separate Postgres clusters using the Postgres Operator for Kubernetes.

https://blog.crunchydata.com/blog/insert-only-tables-and-autovacuum-issues-prior-to-postgresql-13

Insert-Only Tables and Autovacuum Issues Prior to PostgreSQL 13 If you have insert-only tables in a version of PostgreSQL earlier that 13, you could benefit from running a regularly scheduled VACUUM.

We're excited to announce the release of PGO 5.0, the open source Postgres Operator from Crunchy Data. While I'm very excited for you to try out PGO 5.0 and provide feedback, I also want to provide some background on this release.

The Next Generation of Kubernetes Native Postgres

Logging Tips for Postgres, Featuring Your Slow Queries Today we're going to take a look at a useful setting for your Postgres logs to help identify performance issues. We'll take a walk through integrating a third-party logging service such as LogDNA with Crunchy Bridge PostgreSQL and setting up logging so you're ready to start monitoring and watching f...

https://blog.crunchydata.com/blog/better-json-in-postgres-with-postgresql-14

Better JSON in Postgres with PostgreSQL 14 A feature highlight of the new JSON subscript support within PostgreSQL 14.