Skip site navigation (1) Skip section navigation (2)

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

From: Yusuf <yusuf0478(at)netscape(dot)net>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Deleting one record from a table taking 17s.
Date: 2003-06-20 17:06:42
Message-ID: 3EF33F22.4000801@netscape.net (view raw or flat)
Thread:
Lists: pgsql-performance

rbt(at)rbt(dot)ca wrote:
> 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.
> 

That's what I thought at first, so I dropped the foreign key constraints.  The table is referenced by 2 tables, one of 
which has around 200 000 records and the other has 0 records.


In response to

Responses

pgsql-performance by date

Next:From: Rod TaylorDate: 2003-06-20 22:04:56
Subject: Re: Deleting one record from a table taking 17s.
Previous:From: Tom LaneDate: 2003-06-20 16:59:00
Subject: Re: Deleting one record from a table taking 17s.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group