Re: DELETE running at snail-speed

From: gerhard <g(dot)hintermayer(at)inode(dot)at>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: DELETE running at snail-speed
Date: 2008-12-18 14:53:11
Message-ID: 671a3c56-a1c4-423a-a081-9dc30e84583d@40g2000prx.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Added indices on the two tables that used foreign keys to the delting
table, and voila - delete finishes fast.
Thanks for the tip, also using explain analyze, as someone else
pointed out, would have shown me, where the problem comes from.

Thanks everybody for helping.
Gerhard

In response to

Browse pgsql-general by date

  From Date Subject
Next Message George Weaver 2008-12-18 15:58:05 Server side large object functions
Previous Message Sam Mason 2008-12-18 14:30:54 Re: DELETE running at snail-speed