Re: Speeding up 'bulk' delete (and/or seeing what is going on while the delete is being processed) - Mailing list pgsql-novice

Tom/Alan,
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).


Thanks again.


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@simkin.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

Steve Tucknott ReTSol Ltd DDI:         01323 488548