Speed difference between Drop table and Truncate table in Postgres
5
votes
3
answers
13788
views
I currently have a program that inserts into a database by creating temp tables, filling the tables, then merging that data into the main tables. Then dropping the tables and doing it all again.
I'm wondering what the speed difference is if instead of drop and create, if I just truncate.
Asked by Francis Lewis
(150 rep)
Mar 25, 2019, 09:51 PM
Last activity: Nov 13, 2023, 04:12 AM
Last activity: Nov 13, 2023, 04:12 AM