Re: Deleting one record from a table taking 17s.

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Yusuf <yusuf0478(at)netscape(dot)net>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Deleting one record from a table taking 17s.
Date: 2003-06-20 16:06:03
Message-ID: 1056125163.41752.31.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 2003-06-20 at 15:53, Yusuf wrote:
> Why would the following query take soo long to run? What does 28.12 msec represent, since the total running time is
> 16801.86 ms.

I'd hazard to guess that you have a whole slew of foreign keys cascading
to delete, update, or check many rows from other tables.

Those are not represented in the explains at the moment.

--
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-06-20 16:59:00 Re: Deleting one record from a table taking 17s.
Previous Message Yusuf 2003-06-20 15:53:28 Deleting one record from a table taking 17s.