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

  • 10 min read

    Use CI/CD to Automatically Update Postgres Images with Argo CD

    Bob Pacheco

    When working with containers you always have to be mindful of the age of the containers. Every day new CVEs are being discovered and are turning up in image scans. One benefit of having a CI/CD pipeline is the ability to implement security automation. Let's assume you release a monthly update of your containers that are built on the latest version of the base image and all of the most recent patches have been applied. This ensures that each month you can remediate any CVEs that might have popped up in your images since their initial release. In this blog we show you how to use ARGO CD Image Updater as part of your CI/CD pipeline to automatically deploy, test, and promote your updated images. All by doing nothing more than putting them into your registry.

    workflow

    This is part 2 of CI/CD with Crunchy Postgres for Kubernetes and Argo series. We will pick up from where we left off in part 1

    Read More
  • Postgres Subquery Powertools: CTEs, Materialized Views, Window Functions, and LATERAL Join

    Elizabeth Christensen

    Beyond a basic query with a join or two, many queries require extracting subsets of data for comparison, conditionals, or aggregation. Postgres’ use of the SQL language is standards compliant and SQL has a world of tools for subqueries. This post will look at many of the different subquery tools. We’ll talk about the advantages and use cases of each, and provide further reading and tutorials to dig in more.

    I’ll take a broad definition of “subquery”. Why am I calling all of these subqueries? These are all queries that work on subsets of data. Having read the article title, you might have come here to say that a subquery is a specific thing vs

    Read More
  • 14 min read

    Fun with PostgreSQL Puzzles: Recursive Functions with Animations

    Greg Sabino Mullane

    Read More
  • 10 min read

    When Did Postgres Become Cool?

    Craig Kerstiens

    Postgres wasn't always the cool kid. It didn't emerge from millions of dollars of VC funding, it didn't have a team of DevRel evangelists championing it, it simply started and evolved. Postgres just passed the 25 year milestone as an open source project. With the upcoming release of Postgres 16 in coming months, we thought we'd pause for a minute and take a look back at Postgres and how it got to where it is today.

    If for some reason you've been living under a rock and are unfamiliar with Postgres, give a read on our write-up of Why Postgres

    Read More
  • XKCD Bad Map Projection with PostGIS

    Paul Ramsey

    Last week, Randall Munroe dropped his latest XKCD "Bad Map Projection", number six, "ABS(Longitude)", which looks like this:

    ABS(Longitude)

    Truly this is a bad map projection, on a par with the previous five:

    Read More
  • Remote Access Anything from Postgres

    Paul Ramsey

    In my last blog post, I showed four ways to access a remotely hosted CSV file from inside PostgreSQL:

    • Using the COPY command with the PROGRAM option,
    • Using the http extension
    Read More
  • 2 min read

    Introducing Database Insights: Effortless Postgres Management with Crunchy Bridge

    Craig Kerstiens

    Today we're excited to announce several big improvements to Crunchy Bridge to make it easier to work with your database without having to become a DBA. Today we're releasing:

    • Database insights: Real-time indicators to ensure a healthy database
    • Metrics: Monitor your system over time
    • Production check: Ensure you're ready for launch day
    Read More
  • 5 min read

    Announcing Crunchy Postgres for Kubernetes 5.4

    Craig Kerstiens

    We are happy to unveil the newest release of Crunchy Postgres for Kubernetes version 5.4. This update brings an array of features set to improve your experience including:

    • Support for ARM
    • Native vector search via pgvector
    • Comprehensive support for huge pages
    • Native support for Postgres tablespaces
    • Documentation enhancements
    Read More
  • 11 min read

    Fun with PostgreSQL puzzles: Surface Area and 3D Slices

    Greg Sabino Mullane

    This article will contain spoilers both on how I solved 2022 Day 18's challenge "Boiling Boulders" using SQL, as well as general ideas on how to approach the problem. I recommend trying to solve it yourself first, using your favorite language.

    aoc_lava_ball

    (heatmap slicing a 3-D piece of lava - all in SQL!)

    Hands on Tutorial

    Read More
  • Performance Tips for Postgres FDW

    Christopher Winslett

    We have a lot of Postgres foreign data wrapper (FDW) users here at Crunchy. The postgres_fdw lets you connect to remote servers and in some cases can be an alternative for traditional ETL/ELT processes. As I see use of the Postgres foreign data wrapper expanding, I wanted to make some recommendations on how to approach performance. When you query from a single Postgres cluster, the database cleverly uses internal statistics to auto-tune performance

    Read More