haki
Re:Postgres Postmaster does not scale
on Thursday February 05, 2026 @12:00AM (#46895849)
Some a prime example of a service that naturally peaks at round hours.
We have a habbit of never scheduling long running processes at round hours. Usually because they tend to be busier.
https://hakibenita.com/sql-tricks-application-dba#dont-sched...
Unconventional PostgreSQL Optimizations
Reliable Django Signals
Re:Supercharge vector search with ColBERT rerank in PostgreSQL
on Thursday January 23, 2025 @11:00PM (#42810404)
See psycopg Identifier for binding table names
https://www.psycopg.org/psycopg3/docs/api/sql.html#psycopg.s...
Re:How to Get or Create in PostgreSQL
on Monday August 05, 2024 @01:38PM (#41163475)
Since at least two people noticed, I would just say that the insert-select-insert approach was added later, after I took some inspiration from Django's implementation of get_or_create.
Re:The Surprising Impact of Medium-Size Texts on PostgreSQL Performanc...
on Wednesday August 30, 2023 @01:21PM (#37325537)
If you store large jsonb values in the database, storing them out of line may be a good thing - for example, you can query metadata much faster.
Also, worth mentioning that jsonb is only benefitial when you plan on indexing/manipulating the data in the database. Otherwise, using json type may be a better choice (smaller size, stored as text, parsed on demand)
Re:The Surprising Impact of Medium-Size Texts on PostgreSQL Performanc...
on Wednesday August 30, 2023 @11:45AM (#37323895)
I used excalidraw.com
You didn’t just do that, Heroku
Re:Features I'd Like in PostgreSQL
on Sunday January 29, 2023 @11:27PM (#34575771)
You can utilize transactional DDL for that
https://hakibenita.com/sql-tricks-application-dba#make-index...
Re:Lesser-known Postgres features
on Tuesday November 09, 2021 @12:43PM (#29164768)
I'm always looking for new copy tricks. Is "copy" a temporary table? Or a variable...?
Practical SQL for Data Analysis: What you can do without Pandas
New Features in Django 3.2
An unexpected find that freed 20GB of unused index space in PostgreSQL
Re-Introducing Hash Indexes in PostgreSQL
Re:Exhaustiveness Checking with Mypy
on Tuesday December 15, 2020 @09:53AM (#25430818)
See relevant section in the article:
https://hakibenita.com/python-mypy-exhaustive-checking#the-f...
Exhaustiveness Checking in Python Using Mypy
The surprising impact of medium-size texts on PostgreSQL performance
Re:Simple Anomaly Detection Using Plain SQL
on Monday September 21, 2020 @01:32PM (#24546131)
Starting at PostgreSQL 12 you don't even have to feel bad about all of those CTE's.
Simple Anomaly Detection Using Plain SQL
Re:Some SQL Tricks of an Application DBA
on Thursday July 30, 2020 @08:28AM (#23997296)