Hacker News new | ask | show | jobs
by mgradowski 1639 days ago
Neither did I. I tend to avoid RBDMS-specific syntax extensions of questionable benefit.

The only thing I really miss in PG is ASOF JOIN. It's possible to implement it via CROSS JOIN LATERAL, but in my case it resulted in nested loops — coming from ClickHouse it bothers me that there is no way (that I know of) to hint PG to use a specific join strategy.