Re: POSTGRES TOO SLOW

"Mario Snchez" <mrxm(at)hotmail(dot)com> writes:
> I recently installed postgres 7.0.1 on a Sun server with
> Solaris 5.7. It is working fine but when i try to do a join of two tables of
> size, let's say 130,000 records one and the other 200,000 it just freezes
> there .... and even if a wait for hours it doesn't give me an answer,

Well, if it's just doing a stupid nested-loop plan then it'd have to
consider all 26 billion cross-product tuples, which might indeed take
awhile. What's the query, *exactly*? What does EXPLAIN say is the
query plan for it? What indexes have you created on the tables?

regards, tom lane