Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: "not in" clause too slow?
- From: Ottavio Campana <ottavio(at)campana(dot)vi(dot)it>
- To: Alban Hertroys <a(dot)hertroys(at)magproductions(dot)nl>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: "not in" clause too slow?
- Date: Tue, 25 Sep 2007 10:47:16 +0200
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.
Attachment:
signature.asc
Description: OpenPGP digital signature
- References:
- "not in" clause too slow?
- From: Ottavio Campana
- Re: "not in" clause too slow?
- From: Alban Hertroys
- "not in" clause too slow?
- Prev by Date: Re: PgpoolAdmin installation
- Next by Date: Re: "not in" clause too slow?
- Previous by thread: Re: "not in" clause too slow?
- Next by thread: Re: "not in" clause too slow?
- Indexes: