Re: on delete cascade slowing down delete - Mailing list pgsql-general

From Joshua Drake
Subject Re: on delete cascade slowing down delete
Date
Msg-id 20080821101944.0e38e036@jd-laptop
Whole thread Raw
In response to Re: on delete cascade slowing down delete  (Alan Hodgson <ahodgson@simkin.ca>)
Responses Re: on delete cascade slowing down delete  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
On Thu, 21 Aug 2008 10:16:21 -0700
Alan Hodgson <ahodgson@simkin.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



pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: on delete cascade slowing down delete
Next
From: David Fetter
Date:
Subject: Re: on delete cascade slowing down delete