Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more
Paul Ramsey
Paul Ramsey
One of the curious aspects of spatial indexes is that the nodes of the tree can overlap, because the objects being indexed themselves also overlap. That means that if you're searching an area in which two nodes overlap, you'll have to scan the contents of both nodes. For a trivial example above, that's not a big deal, but if an index has a lot of overlap, the extra work can add up to a measurable query time difference. The PostGIS spatial index is based on a R-tree structure, which naturally t...
Read MoreElizabeth Christensen
Elizabeth Christensen
Crunchy Data hosted the third annual PostGIS Day on November 18th.This was our second year with a virtual format and another year of record attendance! We had attendees from more than 99 countries. PostGIS is the most popular geospatial database in the world, with: • over 300 vector and raster functions • high performance analytical and transactional functionality • easy integration with all third-party mapping and data processing tools over 300 vector and raster functions high perform...
Read MoreJonathan S. Katz
Jonathan S. Katz
One of the many reasons " the answer is Postgres " is due to its extensibility. The ability to extend Postgres has given rise to an ecosystem of Postgres extensions that change the behavior of the database to support a wide range of interesting capabilities. At Crunchy Data we are big fans of PostGIS , the geospatial extender for Postgres. Another extension we are asked about often is TimescaleDB . TimescaleDB is an open-source extension designed to make SQL scalable for time-series data....
Read MoreJonathan S. Katz
Jonathan S. Katz
Did you know that PostgreSQL 12 introduced a way for you to provide multifactor (aka "two-factor") authentication to your database? This comes from the ability to set as part of your pg_hba.conf file, which manages how clients can authenticate to PostgreSQL. When you specify , PostgreSQL requires a connecting client to provide a certificate that is valid against its certificate authority ( CA ) and the certificate's common name ( CN ) matches the username the client is authenticating...
Read MoreJonathan S. Katz
Jonathan S. Katz
I recently wrote an example of how you can project monthly recurring revenue ( MRR ) in Postgres . This is a helpful metric to understand how a subscription-based business is doing and can help inform all sorts of financial and operational decisions at the company. Since writing that example, my same friend running their SaaS business on Crunchy Bridge wanted to find out how much revenue they were accruing per day over the course of a month. When a new month started, the accrued revenue wou...
Read MoreJonathan S. Katz
Jonathan S. Katz
You've built an application and are using Postgres to run it. You move it into production. Things are going great. So great that you've accumulated so much data that you need to resize your disk. Before the cloud, this often involved either expanding your disk partitioning or getting a new disk, both of which are costly operations. Cloud has made this much easier: disk resizes can occur online or transparently to the application, and can be done as simply as clicking a button (such as in Crunch...
Read MoreCaitlin Strong
Caitlin Strong
Crunchy Data products often include High Availability. Patroni and etcd are two of our go-to tools for managing those environments. Today I wanted to explore how these work together. Patroni relies on proper operation of the etcd cluster to decide what to do with PostgreSQL. When communication between these two pieces breaks down, it creates instability in the environment resulting in failover, cluster restart, and even the the loss of a primary database. To fully understand the importance of...
Read MoreCraig Kerstiens
Craig Kerstiens
Whether you are starting a new development project, launching an application modernization effort, or engaging in digital transformation, chances are you are evaluating Kubernetes. If you selected Kubernetes, chances are you will ultimately need a database . While many have success with Kubernetes-native database deployments, others prefer the benefits of a managed database. When it comes to databases, at Crunchy Data we believe the answer is more often than not Postgres, and the question is h...
Read MoreDouglas Hunley
Douglas Hunley
Crunchy Data is proud to announce an update to the CIS PostgreSQL Benchmark by the Center for Internet Security ( CIS ). CIS is a nonprofit organization that publishes best practices and standards for securing modern technology and systems. This newly published CIS PostgreSQL 14 Benchmark ads to the existing CIS Benchmarks for PostgreSQL 9.5 - 13 and builds upon Crunchy Data's ongoing efforts with the PostgreSQL Security Technical Implementation Guide (PostgreSQL STIG ). A CIS Benchmark is...
Read MoreJonathan S. Katz
Jonathan S. Katz
As more data workloads shift to running on Kubernetes , one of the important topics to consider is security of your data. Kubernetes brings many conveniences for securing workloads with the ability to extend security functionality databases through the use of the Operator pattern . Database security best practices on Kubernetes is a frequent conversation we're having with our customers around deploying PostgreSQL on Kubernetes with PGO , the open source Postgres Operator from Crunchy Dat...
Read More