Re: on delete cascade slowing down delete

From: Joshua Drake <jd(at)commandprompt(dot)com>
To: Alan Hodgson <ahodgson(at)simkin(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: on delete cascade slowing down delete
Date: 2008-08-21 17:19:44
Message-ID: 20080821101944.0e38e036@jd-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 21 Aug 2008 10:16:21 -0700
Alan Hodgson <ahodgson(at)simkin(dot)ca> wrote:

> > Any hint to track down the problem?
>
> 1) Define slow.
>
> 2) Tell us what your disk subsystem consists of.
>
> 3) Are there any delete triggers on the tables?
>

And the EXPLAIN ANALYZE

Joshua D. Drake

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2008-08-21 18:02:47 Re: on delete cascade slowing down delete
Previous Message Alan Hodgson 2008-08-21 17:16:21 Re: on delete cascade slowing down delete