search

MaterializeInc / materialize

The data warehouse for operational workloads.
https://materialize.com
Other
5.66k stars 457 forks source link

sql: DROP ... CASCADE can be slow #26373

Closed ParkMyCar closed 1 month ago

ParkMyCar commented 3 months ago

What version of Materialize are you using?

v0.94.2

What is the issue?

Running a DROP ... CASCADE can be relatively slow because we collect all of the items to drop at the planning stage and then is subject to a similar issue as seen in https://github.com/MaterializeInc/materialize/pull/26361

chaas commented 2 months ago

Looked at stats for current blue/green use cases and the drop can be as slow as 7s, which should be improved, but is not as severe as https://github.com/MaterializeInc/materialize/pull/26361. @ParkMyCar ran some tests that are consistent with this number. See https://materializeinc.slack.com/archives/C02FWJ94HME/p1712178602536649 for more details. Moving this to the backlog for now.