Re: Query runs too long for indexed tables

From: PFC <lists(at)peufeu(dot)com>
To: Andrus <eetasoft(at)online(dot)ee>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Query runs too long for indexed tables
Date: 2006-04-05 10:22:53
Message-ID: op.s7i5sfy2cigqcu@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> UPDATE firma1.rid SET toode=NULL
> WHERE toode IS NOT NULL AND
> toode NOT IN (SELECT TOODE FROM firma1.TOODE);

Why not use a LEFT JOIN for this ?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrus 2006-04-05 10:40:25 Re: Query runs too long for indexed tables
Previous Message Andrus 2006-04-05 09:39:46 Re: Query runs too long for indexed tables