Re: Very slow DELETE on 4000 rows of 55000 row table

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Bryce Nesbitt <bryce1(at)obviously(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Very slow DELETE on 4000 rows of 55000 row table
Date: 2007-04-05 04:46:10
Message-ID: 880852.63314.qm@web31801.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> But I DELETE all conflicting those rows prior to the slow DELETE, just
> so the FK check is never hit. Should I be looking at subverting the FK
> check mechanism somehow? The necessary index would be huge, and
> relevant only on this particular operation which happens every few
> months, if that.

true, but without an index, it still has to scan the table just to be sure.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2007-04-05 05:11:27 Re: slow query
Previous Message Bryce Nesbitt 2007-04-05 04:17:19 Re: Very slow DELETE on 4000 rows of 55000 row table