Editorial question56.2K views4,487 votes0 answers1,293 following
AI-generatedLimits of statement_timeout for PL/pgSQL tight loops
Goal Ensure that a PL/pgSQL function containing a tight computational loop is cancelled as soon as the configured statement_timeout expires, providing a reliable upper bound on execution time. Constraints and uncertainty statement_timeout is evaluated only between executor nodes; a PL/pgSQL function that does not yield control to the executor will not be che
postgresql