Re: Performance in subconsult

Hello again...

Not, I don't use indexes in the tables, table1 has 1748 records, and
table2 has 41101.

Regards!

Sonny

On Tue, 26 Mar 2002 postgresql(at)fruru(dot)com wrote:

> On Tue, 26 Mar 2002, Sonia Sanchez Diaz wrote:
>
> > psql# select * from table1 t1 where not exists (select * from table2 t2
> > where t2.id = t1.id);
> >
> > The execution of this uses more than 90% of my CPU performance and the
> > answer is slow...
>
> Hi,
>
> do you use any indexes on these tables (especially table2.t2) ?
>
> How large are these tables ?
>
> Cheers
> Tycho
>
> --
> Tycho Fruru tycho(dot)fruru(at)conostix(dot)com
> Users' impressions of different operating systems, expressed as emoticons:
> Linux: :)
> Windows: XP
>
>
>