Re: Deleting takes days, should I add some index?

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Deleting takes days, should I add some index?
Date: 2021-02-25 21:54:01
Message-ID: CAADeyWjfFzvioskiYXp+fUQqbihHnPjEchKCktH4nEHAJdtLCA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you for the explanation, David

On Thu, Feb 25, 2021 at 9:49 PM David Rowley <dgrowleyml(at)gmail(dot)com> wrote:

>
> Since your foreign keys perform a cascade delete on the tables
> referencing the tables you're deleting from, any records in those
> referencing tables will be deleted too. You must also look at those
> referencing tables and see what references those and index the
> column(s) which are referencing.
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rumpi Gravenstein 2021-02-25 23:19:39 PostgreSQL Licensing Question for pg_crypto and tablefunc extensions
Previous Message Pavel Stehule 2021-02-25 21:40:58 Re: Deleting takes days, should I add some index?