3 ms·
I had the same thoughts. Is there any reason to keep it? Is there any scenario where that invalid index could be useful?
by Buttons840 6y ago
I had the same thoughts. Is there any reason to keep it? Is there any scenario where that invalid index could be useful?
- jeltz 6y agoThe 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.