logoalt Hacker News

ethan_smithlast Tuesday at 10:08 PM0 repliesview on HN

The optimization should work well for your sampling query since the ORDER BY and LIMIT operations would happen before materializing the large columns, but the randomization function might force early evaluation - worth benchmarking both approaches.