Tootfinder

from my link log —
A PostgreSQL developer's .psqlrc
https://news.ycombinator.com/item?id=23826037
saved 2020-07-13 https://dot…

from my link log —
Mailchimp's Mandrill outage due to PostgreSQL XID wraparound.
https://mailchimp.com/what-we-learned-from-the-recent-mandrill-outage/
saved 2019-04-01

What We Learned from the Recent Mandrill Outage | Mailchimp
Following a recent outage, we committed to sharing what we learned with our customers. The outage began at 05:35 UTC on February 4, and we resolved the issue...

Perhaps one of my next projects is to set up a Mastodon instance (may be this one) on a cluster of 3 or more Raspberry Pi's. Still no exact imagination on how to distribute the different services in a meaningful manner. An example could be:
🖥️ Node Roles
pi-master: PostgreSQL, Redis, Reverse Proxy
pi-worker1: Web (Rails), Streaming
pi-worker2: Sidekiq, Web (replica)
#mastodon

from my link log —
Instant database clones with PostgreSQL 18.
https://boringsql.com/posts/instant-database-clones/
saved 2025-12-23 https://

Instant database clones with PostgreSQL 18
Learn how to clone PostgreSQL databases instantly using reflinks. Turn slow template copies into milliseconds with PostgreSQL 18's new file copy options.

Wir suchen ab sofort eine/n Backend Developer mit Skills in Rust, PostgreSQL, Next.js und Zeit und Lust in einem kleinen Team die eMobilität voranzubringen.
Nicht für Geld sondern für die Community, dafür für ein echtes Projekt mit ab und zu Dank und Mitgestaltungsmöglichkeiten.
malik@ladefuchs.app

from my link log —
Do you really need Redis? PostgreSQL does queuing, locking, and pub/sub.
https://spin.atomicobject.com/2021/02/04/redis-postgresql/
saved 2021-06-12

Do You Need Redis? PostgreSQL Does Queuing, Locking, & Pub/Sub
It's a common architecture to have PostgreSQL and Redis serve as the backbone of your app, but PostgreSQL may be capable of everything you use Redis for.

Alright, time to kick the tires on Vaultwarden. Got it installed, SSL and SMTP configured as well as proper `nginx` rules. The export from 1Password imported perfectly fine, and it's running great on a 2 vCPU/4 GiB of RAM VM. I did run Bitwarden for a short while, but I'd rather have a PostgreSQL backend than the MSSQL one.
Satisfied so far.
#vaultwarden

Dang it, PostgreSQL is so good.
I did a data export thing. The options I needed were there. Then I needed more options, and then they were also there. They worked the way I guessed. It was fast. It was reliable. Then I thought “oh, what about sequences?!?”, but they already had that covered. My seemingly easy task turned out to be…easy.

🧑‍💻 Whether it’s PostgreSQL or a passion project, we want it on the SCaLE 23x expo floor! Booths are free for community orgs—nominate now:
https://www.socallinuxexpo.org/blog/23x-booth-grants

The year is 2025, I just moved the PostgreSQL DB for my mastodon instance off of one disk onto another.
This is the best timeline for the tech world.

from my link log —
pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search.
https://github.com/timescale/pg_textsearch
saved 2025-12-18

GitHub - timescale/pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed.
PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed. - timescale/pg_textsearch

Nextcloud: MariaDB or PostgreSQL? What gets better support by the devs?
#nextcloud

That was slightly more drama updating to Mastodon v4.5.0 than I wanted.
The OS restarted while the database migration was in progress so I had to restore the database from backups.
Except this took some time because of the size of the database and the fact that the backup software I have for the #PostgreSQL server needs to rewrite the entire database to restore older versions.
#MastoAdmin

Today an upgrade of Debian 10 to 13 and PostgreSQL 11 to 18. Nothing weird except some mosquitto plugin hassle and a huge misjudgment of to be allocated disk space for the new database. 67Gb is not my perceived 6.7Gb... I misread it several times.

Olipa kyllä mielenkiintoinen aikaleima kännykällä tallennetussa träkissä. (mökin koordinaatit anonymisoitu). Ekaksi ajattelin, että olisi bitti nyrjähtänyt mutta pikaisesti katsottuna 12 bittiä olisi pitänyt kääntyä mikä ei tunnu todennäköiseltä.
Muuten kyllä selvisi, että olen vapusta 2019 lähtien viettänyt eniten aikaa kotona, sitten töissä ja mökillä. Olisiko tuon selvittämiseksi todella tarvinnut ajaa läppirllä postgresql:lää reilut 20 tuntia? Tuskin saamme koskaan tietää.

from my link log —
How GitLab.com upgraded PostgreSQL.
https://about.gitlab.com/blog/2020/09/11/gitlab-pg-upgrade/
saved 2020-09-12 https:…

How we upgraded PostgreSQL at GitLab.com
We explain the precise maintenance process to execute a major version upgrade of PostgreSQL.

🐘 PostgreSQL? ☁️ Kubernetes? 🦀 Rust? 🛠️ Automation?
If you use it, build it, or broke it—we want to hear about it.
#SCaLE23x

MobilityDuck: Mobility Data Management with DuckDB
Nhu Ngoc Hoang, Ngoc Hoa Pham, Viet Phuong Hoang, Esteban Zim\'anyi
https://arxiv.org/abs/2510.07963 https://

MobilityDuck: Mobility Data Management with DuckDB
The analytics of spatiotemporal data is increasingly important for mobility analytics. Despite extensive research on moving object databases (MODs), few systems are ready on production or lightweight enough for analytics. MobilityDB is a notable system that extends PostgreSQL with spatiotemporal data, but it inherits complexity of the architecture as well. In this paper, we present MobilityDuck, a DuckDB extension that integrates the MEOS library to provide support spatiotemporal and other temp…

from my link log —
pglinter: database linting and analysis for PostgreSQL.
https://pglinter.readthedocs.io/en/latest/
saved 2025-10-14 https://

#pgaiquery v0.1.0 — First stable release brings multi-model #AI directly into #PostgreSQL #opensource

from my link log —
Locks in PostgreSQL.
https://habr.com/en/company/postgrespro/blog/504498/
saved 2020-06-03 https://dotat…

Locks in PostgreSQL: 3. Other locks
We've already discussed some object-level locks (specifically, relation-level locks), as well as row-level locks with their connection to object-level locks and also explored wait queues, which are...

Redefining Cost Estimation in Database Systems: The Role of Execution Plan Features and Machine Learning
Utsav Pathak, Amit Mankodi
https://arxiv.org/abs/2510.05612 https://

Redefining Cost Estimation in Database Systems: The Role of Execution Plan Features and Machine Learning
Accurate query runtime prediction is a critical component of effective query optimization in modern database systems. Traditional cost models, such as those used in PostgreSQL, rely on static heuristics that often fail to reflect actual query performance under complex and evolving workloads. This remains an active area of research, with recent work exploring machine learning techniques to replace or augment traditional cost estimators. In this paper, we present a machine learning-based framewor…

from my link log —
So you want the PostgreSQL JIT to be faster than an interpreter on modern CPUs…
https://www.pinaraf.info/2025/10/jit-so-you-want-to-be-faster-than-an-interpreter-on-modern-cpus/
saved 2025-10-13

from my link log —
What's new in PostgreSQL 18.
https://www.bytebase.com/blog/what-is-new-in-postgres-18-for-developer/
saved 2025-09-29

from my link log —
A workflow for maintaining feature branches and submitting patches to PostgreSQL.
https://blog.2ndquadrant.com/maintaining-feature-branches-submitting-patches-git/
saved 2019-01-15