POSTGRES TOO SLOW
От | Mario Sánchez |
---|---|
Тема | POSTGRES TOO SLOW |
Дата | |
Msg-id | F227x3Vp20N39x6HHGN00013484@hotmail.com обсуждение исходный текст |
Ответы |
Re: POSTGRES TOO SLOW
|
Список | 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.
В списке pgsql-novice по дате отправления: