#​498 — March 22, 2023

Web Version

Together with  Sticker Mule

Postgres Weekly

Easy Postgres Time Bins — Some tricks to ‘bin’ time-based data for generating useful graphs and reports. With functions like generate_series(), width_bucket(), floor(), and date_bin(), you can group data sets in different ways and quickly retrieve query-based reports.

Paul Ramsey

Site Reliability Engineer And Software Engineer C++ — Join our "kick ass" team. Our software team operates from 17 countries and we're always looking for more exceptional engineers.

Stickermule sponsor

Announcing Postgres 15 on Heroku — Once the front runner in providing a managed Postgres service, Heroku has now brought Postgres 15 on board for all new apps going forward and you’re encouraged to upgrade ASAP if you’re using 9.6 or 10.



Table Maintenance after Bulk Modifications — Making large modifications to tables can skew the statistics used by Postgres’s query planner, so recalculating these statistics can be a wise move after making such changes. ANALYZE table_name to the rescue.

Tobias Petry

How Collation WorksCollation refers to the rules around how a system should compare and sort strings. Here, Peter Eisentraut explains how collations work in Postgres and the role of Unicode in defining collation standards.

Peter Eisentraut

DELETE vs. TRUNCATE — Find out how DELETE and TRUNCATE differ when you want to get rid of data. The main difference is between operating at the row and table level.

Hans-Jürgen Schönig

Basic Time-Series Data with Rails and Postgres — A good place to start if you are dealing with time-series data and aren’t ready to jump to something more dedicated.

Saad Syed (Census Engineering)

🛠 Code and Tools

pgwarehouse: Sync a Postgres Database to a Snowflake or Clickhouse Warehouse — The author said on Hacker News: “Built this recently to help a friend setup a Snowflake warehouse from their Postgres database. Also tested it with ClickHouse which is cool for running locally. Uses simple COPY which is fast and doesn’t require binlog access, but doesn’t support real-time replication as a result.”

Scott Persinger

Tuple, a Lightning-Fast Pairing Tool Built for Remote Developers

Tuple sponsor

PgLock 1.0: Use Advisory Locks to Isolate Code Execution Across Machines — Aimed at Rubyists, but it’s interesting to see Postgres so directly used to manage locks across non-database related processes.


Frenzy: Postgres Wire Protocol Aware Mirroring Proxy — It’s early days for this Go-based Postgres proxy, but it’s fun to see something at this stage that does actually work and may be useful if you need to build something similar of your own.. “It’s suuuuuper hacky but in 2 hours of work I was able to proxy some queries!”

Kelly Sommers