Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more

Latest posts from Elizabeth Christensen

  • Postgres Indexes for Newbies

    Elizabeth Christensen

    If you’ve read Crunchy blogs recently you probably noticed by now that we’re all big fans of indexing. Indexing is key to optimizing your database workloads and reducing query times. Postgres now supports quite a few types of indexes and knowing the basics is a key part of working with Postgres. The role of database indexes is similar to the index section at the back of a book. A database index stores information on where a data row is located in a table so the database doesn't have to scan...

    Read More
  • 4 min read

    PostGIS Day 2021

    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 More
  • Postgres is Out of Disk and How to Recover: The Dos and Don'ts

    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 More
  • Database Terminology Explained: Postgres High Availability and Disaster Recovery

    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 More