Crunchy Data

11/19/2024

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

10/05/2023

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.

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.

07/31/2023

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.

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

07/25/2023

https://www.crunchydata.com/blog/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.

07/27/2022

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.

01/05/2022

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

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

08/26/2021

https://blog.crunchydata.com/blog/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.

07/08/2021

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.

06/24/2021

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

06/10/2021

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

A feature highlight of the new JSON subscript support within PostgreSQL 14.