Latest posts from Christopher Winslett
JSON Updates in Postgres 16
Chris digs into some example code for the new JSON features that just launched with Postgres 16 last week. A new check for finding json objects and some new object and array functions.
6 min readHNSW Indexes with Postgres and pgvector
pgvector for Postgres recently got a big upgrade with the new HNSW indexes. Chris explains what they are, how to use them, and what the accuracy and performance implications are for adding these.
12 min readScaling Vector Data with Postgres
pgvector for AI in Postgres catch your eye? Start thinking about scaling and performance now. Chris has some tips about partitioning and truncating data to strike that perfect balance between performance and accuracy.
12 min readPerformance Tips for Postgres FDW
Chris has some tips on helping you get the most out of queries when working with a remote Postgres foreign data wrapper. He has an overview of how queries are executed with the fdw and then samples for using CTEs, sub-queries, materialized views, and more.
8 min readHigh-compression Metrics Storage with Postgres Hyperloglog
Hyperloglog is a Postgres extension for doing high-compression storage and query approximations. Chris shows you how to get started building a metrics system inside your Postgres database while saving on storage space and query time.
13 min readPerformance Tips Using Postgres and pgvector
AI has exploded the amount of vector data being generated. Getting performance can be uncertain, until you know the keys. Chris explains the 3 basics you need to get performance out of vector data with Postgres.
7 min readSolving N+1 Postgres queries for Ruby on Rails apps
Chris has some tips for working with Ruby on Rails and ActiveRecord and using better SQL to improve performance and avoid N+1 queries.
6 min readWriting Data from Postgres to MongoDB
Chris has some sample code for synching data from Postgres to MongoDB using Foreign Data Wrappers and Triggers.
7 min readEasy Mongo from your Postgres
To continue to provide developers with the best Postgres experience, Crunchy Bridge now offers easy connectivity between managed Postgres and MongoDB.
4 min readWhat'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.
7 min readPostgres support for JSON is 10 years old!
JSON in Postgres is now 10 years old. Chris recently published a JSON tutorial and offers some thoughts on the past and future of JSON, and what developers need to be aware of.
5 min readPhases of Database Growth and Cost
When it comes to database performance, many think they are solving technical problems, but are solving a money problem. There are 2 phases to database-cost management, and understanding which phase you are in will help you understand your options for growth.
7 min readPostgres Traceability: Use SQL Comments Like a Stacktrace
Which of my applications ran this SQL statement? Use SQL comments to track which application ran which queries.
4 min readDemystifying 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 min read
