Dear PostgreSQL Hackers, I've discovered an issue with dropping a large table (~5T). I was thinking drop table is fast operation however I found out my assumption was wrong.
Is there any way how to tune it to drop a large table in the matter of seconds or minutes? Any configuration variable in the postgresql.conf or any tune up options available?
drop table should be fast.
There can be two reasons why not:
1. locks - are you sure, so this statement didn't wait on some lock?
2. filesystem issue - can you check the speed of rm 5TB file on your IO?