Are you referring to the fact that CTEs are an optimization boundary in PostgreSQL and (presumably) most other systems? In any case, most of the time I'm the DBA so it doesn't really matter ;)