Thanks. 300,000+ rows deleted in under 10 minutes (may have been a lot
less - I went to get a coffee, came back and it was done).
PS Is there a reason that PostgreSql doesn't automatically create the
foreign key indexes?
On Thu, 2009-08-27 at 13:17 -0400, Tom Lane wrote:
> Alan Hodgson <ahodgson(at)simkin(dot)ca> writes:
> > Do you have other foreign keys into supplierProduct on other tables where
> > the relevant columns aren't indexed? Slow deletes are usually caused by
> > that.
> Yeah. The query plan itself looks perfectly reasonable, so I'm
> suspecting the problem is something happening subsequent to the row
> deletions --- like foreign key constraint checking.
> regards, tom lane
DDI: 01323 488548
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2009-08-27 18:18:58|
|Subject: Re: Speeding up 'bulk' delete (and/or seeing what is going on while the delete is being processed) |
|Previous:||From: Jignesh Shah||Date: 2009-08-27 18:04:02|
|Subject: Re: Trigger for Truncate event|