Just another geek
Previously… In our first JIT episode, we discussed how we could, using copy-patch, easily create a JIT compiler for PostgreSQL, with a slight improvement in performance compared to the PostgreSQL interpreter. In our second episode, I talked about the performance wall and how hard it was to have a real leap in performance compared to [ ]
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, [ ]
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 [ ]
Hello In the past years, Calligra has not been very active. Since a few months, we are trying to improve the situation and come back. We need great office suites. We need components we can reuse in our applications. We need a Plasma-mobile document viewer. This is what Calligra can be, this is what Calligra [ ]
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 [ ]
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 [ ]
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, [ ]
Two months ago, I reviewed the Packt Publishing book Instant PostgreSQL Starter . And two weeks ago, Packt Publishing offered me to review their latest PostgreSQL book, “PostgreSQL Server Programming”. I was looking forward reading that book. I m, like a lot of PostgreSQL users, quite fond of using as much server-side features and functions as [ ]
After almost two years of lobbying at work to promote PostgreSQL instead of MySQL, after two years of tears against poor DB typing, lack of advanced SQL features, traps in what seemed like basic needs (select * from myview where a=5, if myview is not «simple», triggers a full scan on the view result)… we [ ]
Thanks to Shaun M. Thomas, I have been offered a numeric copy of the Instant PostgreSQL Backup book from Packt publishing, and was provided with the Instant PostgreSQL Starter book to review. Considering my current work-situation, doing a lot of PostgreSQL advertising and basic teaching, I was interested in reviewing this one Like the Instant [ ]