Version 9.5 also has new features that target users of large databases. PostgreSQL’s new indexing system, BRIN (block range indexes), allows for fast queries on large tables by storing only the ...

For faster queries, PostgreSQL 11 offers the option, disabled by default, to perform just-in-time (JIT) compilation on some query expressions, using the LLVM compiler framework.JIT compilation is ...