What is your delete, partitioning, backup strategy?

Hi everyone!!

I would like to hear your thoughts about.

  1. A good way to delete a large number of rows from one rowstore or columnstore table?
    For example, setting engine variables (such as logging) before executing a delete statement.

  2. Is there a good use case for partitioning or backup a table?

Thank you very much.

  1. Since MemSQL is a distributed system performance of deletes is amortized over all the nodes. Let’s us know if you have a specific use case where deletes are slow.

  2. MemSQL doesn’t support partitioning in the Oracle sense. However you can cluster a columnstore table on a specific key and deletes that match this key would be very fast. If you share your use case we can help optimize it.