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:19:39
Message-ID: 66796799-5663-448b-93c6-338b2121c051@i18g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Dec 18, 2:46 pm, gerhard <g(dot)hinterma(dot)(dot)(dot)(at)inode(dot)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. :-(

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-12-18 14:21:28 Re: DELETE running at snail-speed
Previous Message gerhard 2008-12-18 13:46:47 Re: DELETE running at snail-speed