devxlogo

Deletion Problem

Deletion Problem

Question:
Is there an option to set deletion without getting logged? I have to delete two years of historical data but would like to keep this year’s data on my 80MB of rows. I created a new table for this year’s data and I truncated the old table. Is there a better way to do this?

Answer:
Unfortunately, there is no way to have a delete statement operate as an unlogged operation. So your way is fine.

As you’ve realized, deleting a year’s worth of data at once is not a simple task. If I did have to delete many records, I would break it up into smaller operations. So perhaps I would delete records for each month or week at a time. In this way, the Server won’t check by being asked to affect millions of rows in one operation.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist