Pinaraf's website

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.

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

Sometimes, I don’t know why I do things.

Hello In the past years, Calligra has not been very active.

We all know, often from a bad experience, the classical “an untested backup is not a backup”.

Hello Row Level Security is one of the lesser known great addition to PostgreSQL 9.5.

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.

Two months ago, I reviewed the Packt Publishing book “Instant PostgreSQL Starter” .

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 «sim…

Thanks to Shaun M.