How can I delete data from a table?

faq
#1

I don’t want to delete the whole table, but I have a set of rows that need to be removed.

#2

To delete data from a table, run a query using the DELETE command.

After deleting a large number of rows from a table, (1) vacuum the table to reclaim storage space and resort rows, and (2) analyze the table to update statistics for the query planner.

For more, see the Redshift article on DELETE.