Tricking PostgreSQL into using an insane – but 200x faster – query plan

1

OctoSQL

#Databases #Big Data #Relational Databases 22 social mentions

2

Materialize

Alternatively, you can install Materialize, configure change data capture to stream the relevant data to it and then write this query as a live view that gets instantly and incrementally updated instead of performing it periodically.

#Database Tools #Databases #Relational Databases 65 social mentions