Re: Query runs too long for indexed tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Andrus <eetasoft@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: Query runs too long for indexed tables
From: PFC <lists@xxxxxxxxxx>
Date: Wed, 05 Apr 2006 12:22:53 +0200
In-reply-to: <e1039l$15ie$1@xxxxxxxxxxxx>
References: <e0ui0o$2v0m$2@xxxxxxxxxxxx> <1144180128.32266.56.camel@xxxxxxxxxxxxxxxxxxxxxxx> <e1039l$15ie$1@xxxxxxxxxxxx>
User-agent: Opera M2/8.51 (Linux, build 1462)

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 ?

Follow-Ups:
- Re: Query runs too long for indexed tables
  - From: Andrus

References:
- Query runs too long for indexed tables
  - From: Andrus
- Re: Query runs too long for indexed tables
  - From: Scott Marlowe
- Re: Query runs too long for indexed tables
  - From: Andrus

Prev by Date: Re: Query runs too long for indexed tables
Next by Date: Re: Query runs too long for indexed tables
Previous by thread: Re: Query runs too long for indexed tables
Next by thread: Re: Query runs too long for indexed tables
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux