Postgres Pro
Downloads
Home   >   mailing lists

Re: Query runs too long for indexed tables - Mailing list pgsql-performance

From PFC
Subject Re: Query runs too long for indexed tables
Date
Msg-id op.s7i5sfy2cigqcu@apollo13
Whole thread Raw
In response to Re: Query runs too long for indexed tables  ("Andrus" <eetasoft@online.ee>)
List pgsql-performance
Tree view 

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

pgsql-performance by date:

Previous
From: "Andrus"
Date:
Subject: Re: Query runs too long for indexed tables
Next
From: "Andrus"
Date:
Subject: Re: Query runs too long for indexed tables