Re: Massive delete performance

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Andy <frum(at)ar-sd(dot)net>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Massive delete performance
Date: 2005-10-11 12:12:11
Message-ID: BF71245B.10304%sdavis2@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 10/11/05 8:05 AM, "Andy" <frum(at)ar-sd(dot)net> wrote:

>> Do you have foreign key relationships that must be followed for cascade
>> delete? If so, make sure that you have indices on them.
> Yes I have such things. Indexes are on these fields. >> To be onest this
> delete is taking the longest time, but it involves about 10 tables.

Can you post explain analyze output of the next delete?

Sean

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2005-10-11 12:19:42 Re: Massive delete performance
Previous Message Andy 2005-10-11 12:05:52 Re: Massive delete performance