SELECT DISTINCT pushdown to do a loose index scan (skip scan)
In the previous post I used WITH RECURSIVE to emulate a DISTINCT ON, by scanning an index with a skip...
Tags: yugabytedb, postgres, distributed, sql