I'm trying to delete a table and create them again in PostgreSQL, but, in more than 24 hours, the command DROP TABLE or TRUNCATE don't finished.
This table have a lot of tuples (millions), but, this command don't have to be fast?
What can I do to delete this table completely?
Unless the information in your postgresql tables is radically different every time you rebuild the database, I would recommend simply updating the changed records.
That being said, dropping a table should be very fast. Make sure that you have no prepared transactions, locks, or viruses.
By the way, truncating makes no sense to do before dropping. See explanation here: https://dba.stackexchange.com/questions/4163/why-use-both-truncate-and-drop
Thanks for the answer Raymond, but I can understand why any of these commands has been taken so long time...
What you suggests with this update?
- Badges
- Science topic
- Similar topics
- Geoscience
- Asia
- India