Hosting Provided By

Re: [GENERAL] "not in" clause too slow?

From: Ottavio Campana <ottavio(at)campana.vi.it>
Date: Tue Sep 25 2007 - 04:47:16 EDT

Alban Hertroys ha scritto:
> Ottavio Campana wrote:

>> 2) how can I speed it up? by using indexes? or by changing the query?

>
> Do you have indices on mytable.id and copy_mytable.id?
> Does using NOT EXISTS get you any better results?

Eventually I had to select not all the table fields but only the primary key and successively loop on the table again. Thus I've been able to exploit the indexes.

application/pgp-signature attachment: OpenPGP digital signature

Received on Tue Sep 25 04:50:18 2007

This message: [ Message body ]
Next message: Martijn van Oosterhout: "Re: [GENERAL] "not in" clause too slow?"
Previous message: Devrim GÜNDÜZ: "Re: [GENERAL] PgpoolAdmin installation"
In reply to: Alban Hertroys: "Re: [GENERAL] "not in" clause too slow?"
Next in thread: Martijn van Oosterhout: "Re: [GENERAL] "not in" clause too slow?"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 11:50:47 EDT