From: | "Mario Snchez" <mrxm(at)hotmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | POSTGRES TOO SLOW |
Date: | 2001-01-11 18:15:32 |
Message-ID: | F227x3Vp20N39x6HHGN00013484@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi, my name is mario sanchez, i work on a telecommunications company on the
dominican republic. 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, and
when i press Crtl+C it breaks, like it's been working on it, but i've waited
a whole night and it hasn't finished. I've done the same query on vfp and
finished in 2 seconds or so, .... maybe i just configured wrongly the
postgres or I don't know. I've read all the faq and manuals i've found
about it and i cant figure out what the problem is, can you help me out with
this?
thanks,
Mario Sanchez
Telecomm. Engineer
TRICOM, DR
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2001-01-11 19:19:37 | Re: Money Data type |
Previous Message | Rosa Maria Carro Salas | 2001-01-11 17:11:20 | RecordSets, getString and charSets |