1
Learn Postgres at the Playground – Postgres compiled to WASM running in browser
Run Postgres in your local web browser with guided tutorials to help you grow your Postgres skills.
Crunchy Data Blog
Deploy enterprise-ready PostgreSQL on your choice of platform and infrastructure with commercial support from Crunchy Data.
- Popular posts
- 15
- Total points
- 3,277
- HN comments
- 891
- Rank
- #352 company
Visit crunchydata.com → On Hacker News May 2022 – Jun 2026
Databases & Data 15Software Engineering 5Systems & Performance 4Web & Frontend 2Infrastructure & DevOps 2Tech Industry & Business 1
2
Postgres full-text search: A search engine in a database (2021)
With Postgres, you don't need to immediately look farther than your own database management system for a full-text search solution. If you haven't yet given Postgres' built-in full-text search a try, read on for a simple intro.
3
An overview of distributed Postgres architectures
Marco just joined Crunchy Data and he reflects on his career in distributed systems in this post. He provides an overview of several options for approaching distributed Postgres workloads and the pros and cons of each approach.
4
When did Postgres become cool?
Craig takes a look at the history of Postgres. From the origins of the project through some of the key production features that make Postgres what it is today.
5
Is Postgres read heavy or write heavy?
A query to find out if Postgres is read heavy or write heavy and tips for optimizing Postgres for both read and write workloads.
6
Tips for a healthier Postgres database (2021)
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
7
Postgres Data Flow
What happens when you query Postgres? Data can actually come from many different places like the application cache, buffer cache, and even down into the physical disk cache. This post surveys the data storage and flow of Postgres data.
8
Demystifying Database Performance for Developers
For developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes. These algorithms and processes are meant to improve performance, but can cause limitations if they are not expected.
9
Pg_parquet: An extension to connect Postgres and parquet
Crunchy Data is excited to release a new extension so you can write Postgres data to Parquet and or pull data from Parquet to Postgres. Craig has the details and sample code.
10
Postgres 15 Merge Command with Examples
We’re excited about the MERGE command in PostgreSQL 15. We have some ideas about using it for data loading with an example use case for remote sensors.
11
British Columbia, Time Zones, and Postgres
This year, British Column has moved to year-round Pacific Time. How does that affect date data?
12
Postgres WAL Files and Sequence Numbers
Go inside the WAL file with this in-depth look at WAL file Log Sequence Number (LSN), WAL segment positions, WAL file names, and pg_switch_wal.
13
Postgres Insider Terminology
If you've ever wondered - What is a tuple? What is a Postgres page? What's the difference between a record and a row? What is a relation? What's an array? What is TOAST? This post is for you! These are terms you hear all the time in the Postgres world. This post breaks down what these terms mean and how they are used.
14
What's Postgres got to do with AI?
Chris is cooking up some examples for us on how to use AI inside Postgres. We have a simple demo of using pgvector and Open AI to grab relationships and query for other similar items.
15
SVG Images from Postgres
We are excited to announce a new set of functions to generate svgs from Postgres and PostGIS! This gives you really easy maps, images, or charts directly from your database. Once you start reading through these samples, you'll want to start playing with images from your database.