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@fruru.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.fruru@conostix.com
> Users' impressions of different operating systems, expressed as emoticons:
> Linux: :)
> Windows: XP
>
>
>