Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Craig Kerstiens
Craig Kerstiens
Reality is messy, and for every, "We've standardized on cloud Amazon, Azure, or GCP" announcement, there are tens or hundreds of apps hidden within an organization running on the "other" cloud. Most workloads don't span across clouds, but every large organization has workloads on each cloud vendor. And for everyone's favorite database (Postgres) we're excited to say you don't have to compromise quality when it comes to which cloud vendor you're running on. Today we're announcing Crunchy Bridge...
Read MoreCraig Kerstiens
Craig Kerstiens
Connection pooling and management is one of those things most people ignore far too long when it comes to their database. When starting out, you can easily get by without it. With 1 or 2 application servers spawning 5-10 connections, even the tiniest of Postgres servers can handle such. Even with our $35 a month hobby plan on Crunchy Bridge , we can push 5,000 transactions per second through which is quite a bit for < 20 connections. As you grow into the hundreds, better connection management...
Read MoreElizabeth Christensen
Elizabeth Christensen
Additional Contributors: David Christensen, Jonathan Katz , and Stephen Frost Welp… sometimes “stuff” happens… and you find yourself having a really bad day. We'd like to believe that every database is well configured from the start with optimal log rotation, correct alerting of high CPU consumption and cache hit ratio monitoring… But that isn't always the case. Part of our job here at Crunchy is to help on the bad days in addition to preparing you to ensure those never happen. One frustrati...
Read MoreDavid Steele
David Steele
The pgBackRest team is pleased to announce the introduction of multiple repository support in v2.33. Backups already provide redundancy by creating an offline copy of your PostgreSQL cluster that can be used in disaster recovery. Multiple repositories allow you to have copies of your backups and WAL archives in separate locations to increase your redundancy and provide even more protection for your data. This feature is the culmination of many months of hard work, so let's delve into why we thin...
Read MoreCraig Kerstiens
Craig Kerstiens
Crunchy Data is pleased to announce its most recent release of pgBackRest: 2.33 with a number of new features including multiple repository support and GCS support. With pgBackRest 2.33 we are especially excited to add support for Google Cloud Storage ( GCS ) , a new addition to Amazon AWS S3 and Azure Repository support. pgBackRest is a reliable, high performance, easy-to-use backup and restore solution for Postgres that can seamlessly scale up to the largest databases and workloads by ut...
Read MoreElizabeth Christensen
Elizabeth Christensen
In my day to day, I'm surrounded by great database engineers. They talk about things like HA and raft protocol and the right and wrong approach for configuring synchronous vs. asynchronous replication. There is a lot of value in all that deep technical knowledge, but for when interacting with customers, I like to boil it down a bit. What I've seen is that for many folks the basics of key database principles can get lost in the details. What follows is a summary of conversations I've had with cus...
Read MorePaul Laurence
Paul Laurence
With the rise of Postgres, new organizations are evaluating how to benefit from its power and flexibility . As that evaluation progresses, Postgres advocates must address the question, "Is Postgres secure?" There are a variety of ways to answer this question, but the short answer is a confident "Yes!" At Crunchy Data, we often collaborate with organizational stakeholders to address this question. Many organizations have used the same collection of databases for years (maybe decades). The id...
Read MorePaul Ramsey
Paul Ramsey
We at Crunchy Data put as much development effort into improving GEOS as we do improving PostGIS proper, because the GEOS library is so central to much geospatial processing. The GEOS library is a core piece of PostGIS. It is the library that provides all the "hard" computational geometry functionality: • Intersections of geometry • Unions of geometry • Differences of geometry • Buffers of geometry • Geometry relationship evaluation Intersections of geometry Unions of geometry Differences of...
Read MoreKat Batuigas
Kat Batuigas
In a previous post, I talked about pg_stat_statements as a tool for helping direct your query optimization efforts. Now let's say you've identified some queries you want to look into. The EXPLAIN command helps you look even closer into an individual query. If you're already proficient in EXPLAIN, great! Read on for an easy refresher. If you're less familiar with it, this will be a (hopefully) gentle introduction on what insights it might help provide. I'm going to demonstrate simple EXPLAIN...
Read MoreJoe Conway
Joe Conway
Welcome to Episode 2 of the "Musings of a PostgreSQL Data Pontiff" series! In this installment I’m aiming to achieve three objectives. First, you should see how the SQL language, as implemented by PostgreSQL , can perform interesting data analysis through the built-in aggregates and other capabilities such as Common Table Expressions (CTEs) and Window Functions . Second, you will get to see how native SQL combines with R code in PL/R in useful ways. And finally, I’ll show how to use PL/R to...
Read More