I encountered a case where a select query with no time filter, blocked the retention policy of a hypertable, which then seemingly caused further locks.
Is this expected functionality, that a long running select that spans the full table can block the retention policy from acquiring its lock on the oldest partition?