X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 640D211F6602
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  5 Apr 2006 07:22:35 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 05867-08
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  5 Apr 2006 07:22:34 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from peufeu.com (boutiquenumerique.com [82.67.9.10])
	by postgresql.org (Postfix) with ESMTP id 283FC11F6615
	for <pgsql-performance@postgresql.org>;
	Wed,  5 Apr 2006 07:22:32 -0300 (ADT)
Received: (qmail 10961 invoked from network); 5 Apr 2006 12:22:55 +0200
Received: from boutiquenumerique.com (HELO apollo13) (82.67.9.10)
	by boutiquenumerique.com with SMTP; 5 Apr 2006 12:22:55 +0200
To: Andrus <eetasoft@online.ee>, pgsql-performance@postgresql.org
Subject: Re: Query runs too long for indexed tables
References: <e0ui0o$2v0m$2@news.hub.org>
	<1144180128.32266.56.camel@state.g2switchworks.com>
	<e1039l$15ie$1@news.hub.org>
Message-ID: <op.s7i5sfy2cigqcu@apollo13>
From: PFC <lists@peufeu.com>
Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Date: Wed, 05 Apr 2006 12:22:53 +0200
In-Reply-To: <e1039l$15ie$1@news.hub.org>
User-Agent: Opera M2/8.51 (Linux, build 1462)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.113 required=5 tests=[AWL=0.113, UPPERCASE_25_50=0]
X-Spam-Score: 0.113
X-Spam-Level: 
X-Archive-Number: 200604/56
X-Sequence-Number: 18140



> 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 ?