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