PostgreSQL Icon

PostgreSQL

PostgreSQL is an open source database system.
53 Stories
All Topics

PostgreSQL phoronix.com

Postgres looks to LLVM's JIT for up to 20% speed up

This was posted back in March, but it’s news to me:

A long-running project has been JIT-compiling SQL queries in PostgreSQL by making use of LLVM’s just-in-time compilation support, rather than passing SQL queries through Postgres’ interpreter. With the LLVM JIT’ed queries, more efficient code is generated by being able to make more use of run-time information and can especially help in increasing the performance of complex SQL queries.

JIT-compiling expressions for PostgreSQL has been found to be up to ~20%+ faster in database tests like TPC-H. Creating indexes was found to be even 5~19% faster with this JIT mode

Hopefully this feature will progress quick enough to land in Postgres 11. 🙏

Benjie Gillam graphile.org

Graphile –  tools for building performant, pluggable GraphQL APIs

PostGraphile is the new incarnation of PostGraphQL (project history), which introspects your Postgres database schema and creates a fully functional GraphQL API for it.

I’ve been poking around with these tools as I get acquainted with the provider side of GraphQL. I don’t think we’ll end up using PostGraphile if/when we ship our public Changelog API (news + podcasts), because I’m a control freak. But it’s been great for getting started quickly and seeing what’s possible. Highly recommended 👌

0:00 / 0:00