Re: DELETE running at snail-speed - Mailing list pgsql-general

From gerhard
Subject Re: DELETE running at snail-speed
Date
Msg-id 671a3c56-a1c4-423a-a081-9dc30e84583d@40g2000prx.googlegroups.com
Whole thread Raw
In response to DELETE running at snail-speed  (gerhard <g.hintermayer@inode.at>)
List 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


pgsql-general by date:

Previous
From: gerhard
Date:
Subject: Re: DELETE running at snail-speed
Next
From: "George Weaver"
Date:
Subject: Server side large object functions