Это описано в документации https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-CAVEATS For example, a comparison against a non-immutable function such as CURRENT_TIMESTAMP cannot be optimized, since the planner cannot know which child table the function's value might fall into at run time. now() - это stable функция, а не immutable
Обсуждают сегодня