Heapfield — Data & databases

Joining a 2 GB fact table with a 5 MB lookup table causes a full shuffle. Any way to avoid it?

Amara Nwosu9asked yesterday

For each customer_id I need the most recent order from orders(id, customer_id, created_at, total).

Tomás Ferreira6asked 3d ago

This query takes ~4 s on a 30M-row table even though created_at has a B-tree index: SELECT * FROM events WHERE date(created_at) = '2026-10-01'; EXPLAIN shows a sequential scan. Why is the index ignored?

Tomás Ferreira6asked last wk.

I have a DataFrame of orders and want only the rows where status is "shipped" and total is above 100. In SQL: SELECT * FROM orders WHERE status = 'shipped' AND total > 100; What is the idiomatic pandas equivalent?

Amara Nwosu9asked Oct '17