Language Selection

English French German Italian Portuguese Spanish

PostgreSQL Optimizer Bits: Semi and Anti Joins

Filed under
Software

Since version 8.4, PostgreSQL has been offering a new optimisation strategy for the optimisation of certain queries: Semi and Anti Joins.

A Semi Join is a specific form of a join, which only takes the keys of relation a into account if these are also present in the associated table b. An Anti Join is the negative form of a Semi Join: that is, a key picked in table a will be taken into account if it is not present in table b.

To summarize, Semi and Anti Joins are specific forms of a join which only take certain keys on the left side into account - where queries want to make sure certain keys exist, but are not concerned with the content of the key itself. This behaviour is already widely known in Object Relation Mappers (ORM) which formulate such queries using EXIST() or NOT EXIST().

Read the optimization results here.

More in Tux Machines

Linux Kernel 4.9.5 Released with Updated Radeon Drivers, KVM and PPC Fixes

A new maintenance update of the Linux 4.9 kernel series was announced today by renowned Linux kernel maintainer and developer Greg Kroah-Hartman, versioned 4.9.5. Coming only five days after the previous point release, Linux kernel 4.9.5 appears to be a big milestone that changes a total of 132 files, with 1515 insertions and 821 deletions. There are numerous improvements implemented in this fifth Linux 4.9 maintenance update, but first we'd like to remind you that Greg Kroah-Hartman recently marked this kernel branch as long-term supported (LTS), yet this is not apparent from kernel.org. Read more

Linux-based IoT gateway certified for Azure

IonSign’s “Gluon GMU491 Cloud Gateway” runs Debian on a TI Sitara SoC and aggregates multiple sensor and Modbus inputs for Azure and AWS. Finland-based IonSign has begun shipping an IoT gateway billed as a “complete industrial grade production unit for data collection and edge computing.” The Debian Linux based Gluon GMU491 Cloud Gateway is designed for collecting sensor, meter, fieldbus, or automation system data and packaging it for direct delivery to commercial cloud platforms. Read more

Red Hat Financial News