450× Faster Joins with Index Condition Pushdown

Comments (1)

marceloaltmann · 2h ago

Straddled joins were still a bottleneck in Readyset even after switching to hash joins. By integrating Index Condition Pushdown into the execution path, we eliminated the inefficiency and achieved up to 450× speedups.

How Linux and Open Source Became Hollywood's Secret VFX Weapon (brainnoises.com)

PyPl is blocking expired domains to halt malware attacks (techradar.com)

Injectable 'skin in a syringe' could heal burns without scars (sciencedaily.com)

Brain-computer interface could decode inner speech in real time (eurekalert.org)

Are Marathons and Extreme Running Linked to Colon Cancer? (nytimes.com)

Firefox: AI-enhanced tab groups (support.mozilla.org)

Sam Altman Shows Me GPT 5 [video] (youtube.com)

Show HN: AI-powered CLI that translates natural language to FFmpeg

Rick Beato talking Universal Music Group copyright claims [video] (youtube.com)

A Freelancer's Guide to Effortless AI-Powered Time Management (flowping.app)

There's a Hollow Knight: Silksong Livestream on August 21 at 10:30AM ET (engadget.com)

RAG-Shot Learning (joecooper.me)

Catching AI Hallucination in SQL: The Chess Example (timeplus.com)

Hollow Knight: Silksong – Special Announcement [video] (youtube.com)

How Sleep Cleans the Brain and Keeps You Healthy (scientificamerican.com)

What is 'AI psychosis' and how can ChatGPT affect your mental health? (washingtonpost.com)

By opening this can of protein powder, you agree to our TOC / arbitration clause (bsky.app)

What's the point of vibe coding if I still have to pay a dev to fix it? (old.reddit.com)

If Nix Then Nix (whimsicalcode.com)

Trump wants NASA to burn a crucial satellite, killing climate change research (latimes.com)

The Rainforests Being Cleared to Build Your R.V (nytimes.com)

The Chatbot Updated. Users Lost a Friend (nytimes.com)

Former YC product lead shares how she builds voice agents (aimodelbehavior.substack.com)

Hollerith 1890 census tabulator and the evolution of the IBM punched card (columbia.edu)

ROG Matrix GeForce RTX 5090 (rog.asus.com)

Missing External Service Metrics After Istio v1.22 → v1.23 Upgrade (chkk.io)

Steep population declines in most countries are expected to have negative impact (nature.com)

CVify – AI-powered CV and resume builder (cvify.lovable.app)

Porn censorship is going to destroy the internet (mashable.com)

Forklifts Require Training (zacsweers.dev)

How to Give Your RTX 4090 Nearly Infinite Memory for LLM Inference (medium.com)

Why AI chatbots make bad teachers – and how teachers can exploit that weakness (zdnet.com)

Specification Grounding: The Missing Link in Vibe Coding (unstract.com)

Show HN: Free privacy-focused PDF tracking with analytics (pdftrackr.com)

Aulico – Track all markets with AI (aulico.com)

Air Canada strike: Flight attendants reach tentative agreement (thestar.com)

Eric Schmidt: Silicon Valley Needs to Stop Obsessing over Superhuman A.I (nytimes.com)

Small Objects, Big Gains: Benchmarking Tigris Against AWS S3 and Cloudflare R2 (tigrisdata.com)

Meta Restructures AI Group Again in Pursuit of Superintelligence (bloomberg.com)

Government must stop children using VPNs to dodge age checks on porn sites (independent.co.uk)

Zed for Windows: What's Taking So Long? (zed.dev)

Show HN: I built a app to find your first users by listening to Reddit community (redditgeniusai.xyz)

Scientists Create Tool That Realistically Relights Photos in 3D (petapixel.com)

Why success is hard to crack (medium.com)

5G Sniffing and Exploit via Software Defined Radio (github.com)

Ask HN: Which LLM service has the fairest pricing for students?

Why nurturing the gut microbiota could resolve depression and anxiety (nature.com)

Filen.io: Next Generation End-to-End Encrypted Cloud Storage (filen.io)

Product Managers would you use this tool (resyncbase.com)

Optimizing Ourselves to Death (ofdollarsanddata.com)

450× Faster Joins with Index Condition Pushdown

Comments (1)