#postgresql – Coffee Break

July 14, 2025

Improving Query Performance via PostgreSQL Table Partitioning – Part II

Welcome to Part II series of exploring postgresql partitioning. If you haven’t already checked out Part I, it has some pre-requisite information. This helps you find out if partitioning is the right solution for you, as it did for me. Table of Contents Key Information To Know Before Starting Partitioned Table Characteristics In addition, I…

Code Snippets, Engineering

#database, #partitioning, #postgresql, #python, #sql
July 13, 2025

Improving Query Performance via PostgreSQL Table Partitioning – Part I

Intro: At work I created a new set of tables to fulfill the business needs. Unfortunately for the first time around, I couldn’t set aside the time consider maintenance of the tables as it was premature to even consider if the business idea would be successful. So, I decided to work on it another time.…

Code Snippets, Engineering

#database, #partitioning, #postgresql, #sql
January 6, 2023

Postgresql -> Cockroach DB

Context: Options for Horizontally scalable databases (to be performant as datasize becomes larger) Decided at the time that Cockroach DB was the best solution. Migration steps required Rewriting incompatible SQL code Load testing Migration When to use CockroachDB? Who uses CockroachDB? Special mentions: Ref:

Engineering

#cockroach-db, #postgresql, #storj-labs
December 29, 2022

Scaling Bloated PostgreSQL DB

Table Bloats Index Bloats How to Prevent Bloat How to Reduce Bloat No one wants to use pg_repack or pgcompacttable when there is no problem with bloat. Another tool not mentioned in the article is pg_squeeze focused on tackling similar bloat issues. DB Major Upgrades (not related to scaling but is also in article) DB…

Engineering

#one-signal, #postgresql

Tag: #postgresql

Improving Query Performance via PostgreSQL Table Partitioning – Part II

Improving Query Performance via PostgreSQL Table Partitioning – Part I

Postgresql -> Cockroach DB

Scaling Bloated PostgreSQL DB