Skip to content
Snippets Groups Projects

PoC for removing partitioned data using foreign keys

    • Closed Issue created by Grzegorz Bizon @grzesiek

    Description

    Like in #357384 (closed) we want to ship a PoC that will prove that we can efficiently remove resources associated with pipelines (builds, stages, artifacts) using foreign keys and ON DELETE CASCADE with partitioned CI/CD schema.

    We want to better understand if using foreign keys with ON DELETE CASCADE will have to scan all partitions to perform a removal. Is it even possible to rely ON DELETE CASCADE with foreign keys in that case https://www.2ndquadrant.com/en/blog/postgresql-12-foreign-keys-and-partitioned-tables/?

    Objectives

    Check if removing resources through foreign keys actually makes it possible to scan all partitions.

    /cc @fabiopitino @mbobin @morefice @jheimbuck_gl

    Edited by Grzegorz Bizon

    Designs

      Child items 0

      2. No child items are currently assigned. Use child items to break down this issue into smaller parts.

      Activity

      Please register or sign in to reply