Hacker News new | ask | show | jobs
by Buttons840 1966 days ago
I had the same thoughts. Is there any reason to keep it? Is there any scenario where that invalid index could be useful?
1 comments

The reason is to make sure aborting the command is fast and safe. PostgreSQL has no infrastructure for spawn background jobs to clean up stuff like this on aborted queries. A patch would probably welcome if it could be done in a good way.