This repository has been archived by the owner on May 2, 2023. It is now read-only.

Slow deletes during merge insert #8

Closed

pingles opened this issue Jan 20, 2015 · 1 comment

Labels

Contributor

pingles commented Jan 20, 2015

Blueshift's default strategy is to merge new data with the existing. This follows Amazon's recommended method (see http://docs.aws.amazon.com/redshift/latest/dg/merge-examples.html for examples).

The delete statement seems to be very slow when run with tables that have primary keys that aren't also sort or distribution keys.

pingles added the enhancement label

Contributor Author

pingles commented Jan 21, 2015

Committed in #9

pingles closed this as completed

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.