Greetings,
We're currently having very poor performance for the following delete query.
DELETE FROM TopTable WHERE id IN (xx, yy, zz);
We've observed that it takes around 7 seconds under normal load to for each
row that's being from TopTable and several minutes pr deleted row under
heavy load.
"i
Many thanks for the swift reply Tom, please see additional input below
/Jona
On 24 April 2014 22:29, Tom Lane wrote:
> Jonatan Evald Buus writes:
> > We're currently having very poor performance for the following delete
> query.
> > DELETE FROM TopTable WHERE id IN (x
On 24 April 2014 23:25, Tom Lane wrote:
> Jonatan Evald Buus writes:
> > On 24 April 2014 22:29, Tom Lane wrote:
> >> I'd really have to bet that you forgot to index one of the referencing
> >> tables.
>
> > *That was our first thought, so we went
