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

From gerhard
Subject Re: DELETE running at snail-speed
Date
Msg-id 66796799-5663-448b-93c6-338b2121c051@i18g2000prf.googlegroups.com
Whole thread Raw
In response to DELETE running at snail-speed  (gerhard <g.hintermayer@inode.at>)
List pgsql-general
On Dec 18, 2:46 pm, gerhard <g.hinterma...@inode.at> wrote:
> oops, should have thought about setting the foreign key constraint
> deferrable, maybe showing this in table definition (\d) would be a
> good idea.
> will recreate my foreign key deferrable and do some timings ...

OK, recreated my foreign key constraints deferrable (actually used in
2 tables) but still deleting at snail speed. :-(

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: DELETE running at snail-speed
Next
From: gerhard
Date:
Subject: Re: DELETE running at snail-speed