Hi Since my previous blog entry about JIT compiler for PostgreSQL, sadly not much happened due to a lack of time, but still some things were done (biggest improvement was the port to ARM64, a few optimizations, implementing more opcodes…). But I am often asking myself how to really beat the interpreter… And on “modern” CPUs, …
Continue reading “JIT: so you want to be faster than an interpreter on modern CPUs…”
Sometimes, I don’t know why I do things. It’s one of these times. A few months ago, Python 3.13 got its JIT engine, built with a new JIT compiler construction methodology (copy-patch, cf. research paper). After reading the paper, I was sold and I just had to try it with PostgreSQL. And what a fun …
Continue reading “Look ma, I wrote a new JIT compiler for PostgreSQL”
We all know, often from a bad experience, the classical “an untested backup is not a backup”. This small story will illustrate that situation, highlight a big wal-e gotcha and remind you to test your backups. TL;DR : wal-e has a “problem” with multiple clusters. Reminder : what is a PostgreSQL backup ? This question …
Continue reading “Wal-e and the gotcha, how I nearly lost 50% of my backups…”
Hello Row Level Security is one of the lesser known great addition to PostgreSQL 9.5. The documentation about it is of PostgreSQL documentation quality of course, but there is a lack of online examples and usages without relying on distinct PostgreSQL users for multi-tenant websites. I recently built a proof of concept using RLS to secure access …
Continue reading “Using Row Level Security with a Django application”
In a application following an intelligent database design, calls to stored procedures happen very often and thus must be done with as little boilerplate as possible. Usually frameworks abstracting calls to the database are just ORMs, ignoring completely stored procedures, making the database stupid and moving all the logic in the application. A year ago, …
