max / makenotwork

188 B · 4 lines History Blame Raw

1	-- Partial index for soft-deleted post filtering (WHERE removed_at IS NULL).
2	CREATE INDEX IF NOT EXISTS idx_posts_not_removed
3	ON posts(thread_id, created_at) WHERE removed_at IS NULL;
4