Latest posts
Announcing the Scheduler for Crunchy Bridge
Crunchy Bridge has a new feature that lets you create automated cron tasks through our user interface.
1 min readHow We Fused DuckDB into Postgres with Crunchy Bridge for Analytics
Marco reveals some of the components behind Crunchy Bridge for Analytics, which extends PostgreSQL for high performance analytics workloads using DuckDB.
6 min readConverting DMS to PostGIS Point Geometry
Elizabeth shows you how to convert data that is in traditional degrees, minutes, and seconds into PostGIS digital geometry.
Time Partitioning and Custom Time Intervals in Postgres with pg_partman
Keith shows off a variety of the time interval options when you create partitioned tables with pg_partman.
10 min readSyncing Postgres Partitions to Your Data Lake in Crunchy Bridge for Analytics
Marco shows how you can combine pg_partman and pg_cron on Bridge for Analytics to set up automated time-partitioning with long-term retention and fast analytics in your data lake.
9 min readCrunchy Bridge for Analytics: Your Data Lake in PostgreSQL
Today Crunchy Data announces a new analytics engine to read cloud object storage files like CSV, JSON, and Parquet with Postgres.
10 min readAuto-archiving and Data Retention Management in Postgres with pg_partman
Automatically archiving data can save you a ton of money and storage space. Keith shows you can set up data retention policies in Postgres using pg_partman.
9 min readBuilding PostgreSQL Extensions: Dropping Extensions and Cleanup
David shares some tricks for cleaning up after dropped extensions. He goes through how to create a event trigger and function for cleaning up a pg_cron task built by an extension.
8 min readRow Level Security for Tenants in Postgres
Craig shows you how to use Row Level Security to isolate and secure data in a multi-tenant application.
3 min readContributing to Postgres 101: A Beginner's Experience
Elizabeth walks through the basics of contributing to Postgres and submitting a patch and getting it approved and in the codebase.
Inside PostGIS: Calculating Distance
Paul dives inside the PostGIS distance calculations to show how efficient and robust these functions are.
5 min readExamining Postgres Upgrades with pg_upgrade
Greg outlines the steps and process for an example upgrade from Postgres version 12 to 16 using the built-in pg_upgrade tool.
12 min readPostgres Performance Boost: HOT Updates and Fill Factor
Elizabeth reviews HOT updates, what they are, how they work, and how you can put them to use for a performance improvement.
Connecting QGIS to Postgres and PostGIS
Elizabeth reviews the basics of how to use Postgres and PostGIS together with QGIS. She includes instructions for loading data from QGIS into Postgres, going the other way and loading Postgres data into QGIS, and writing layers in QGIS using SQL.
Migrate from Heroku Postgres to Crunchy Bridge
Craig announces a new tool for automatically migrating Heroku Postgres databases to Crunchy Bridge.
4 min readThe Rest is History: Investigations of WAL History Files
Brian steps through reviewing WAL history files and a sample recovery scenario.
9 min readPostGIS Clustering with K-Means
Paul has a primer on using clustering in PostGIS with the K-means algorithm. He uses a global population density map and offers some tips for geocentric and weighted clustering.
3 min readPostgres Not Starting: The Case of the Missing Output
Greg debugs Postgres that is not starting and there are no logs, no pg_ctl start up file, and no output anywhere.
5 min readCrunchy Bridge: Announcing Postgres Insights in Your CLI
Craig announces a suite of useful queries for Postgres in our command line tool. Quickly find cache hit ratio, table sizes, locks, long running queries, indexes, and more in the new query menu for Crunchy Bridge.
5 min readJSON and SVG from PostGIS into Google Sheets
Postgres data delivered straight into Google Sheets! Walk through using pg_featureserv to create JSON and pg_svg to create accompanying SVG images directly from your database and into spreadsheets.
