Tootfinder

#MastoAdmin I just upgraded #postgresql from v17 to v18 without any problems !

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

from my link log —
The evolution of logical replication in PostgreSQL: a historical overview.
https://www.enterprisedb.com/blog/evolution-logical-replication-postgresql-firsthand-account
saved 2025-09-12

The Evolution of Logical Replication in PostgreSQL: A Firsthand Account
PostgreSQL has come a long way from its early days as a single-node database. If you’ve worked with PostgreSQL for a while, you’ll know its journey to robust logical replication was anything but straightforward, shaped by community efforts, creative workarounds, and an ever-evolving need for high availability and flexibility. Having been closely involved in projects like londiste, pglogical, multiple iterations of PGD (BDR) and the built-in logical replication in PostgreSQL itself, I’ve h…

What if we treated Postgres like SQLite?
#postgresql

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.

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.

What if we treated Postgres like SQLite?
#postgresql

#PostgreSQL for everything
https://postgresforeverything.com/

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

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

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

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.

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.

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

from my link log —
Tuning async IO in PostgreSQL 18.
https://vondra.me/posts/tuning-aio-in-postgresql-18/
saved 2025-09-26 https://

In http://rachelbythebay.com/w/2025/09/11/debtz/ Rachel complains about a change in the Debian tzdata package that changed behaviour of PostgreSQL in a surprising way, without a NEWS item for the package update nor a warning in the release notes.
Here is the Debian bug report:

📊 Supports #MySQL #PostgreSQL #SQLite and SQL Server with automatic collations
🛠️ Works with existing Laravel models and database
No complex setup required
⚡ Handles 100 cards…

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ää.

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…

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 —
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

🚀 90-second installation process
Single artisan command board generation
Automatic database collation handling
📊 MySQL/MariaDB with utf8mb4_bin collation
PostgreSQL with C collation
SQLite with binary collation
SQL Server with Latin1_General_BIN2
🌐 https://github.com/Relaticle/flowforge

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 —
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 —
Indexing JSONB in PostgreSQL.
https://www.crunchydata.com/blog/indexing-jsonb-in-postgres
saved 2025-08-21

Indexing JSONB in Postgres | Crunchy Data Blog
Level up with JSONB by adding GIN indexes. Also review when not to use a GIN index and how to leverage expression indexes.

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...