How should IEnumerable versus IQueryable be designed for production in LINQ?

Keep database filtering and projection in IQueryable until materialization, then switch to in-memory processing only when needed.