Hello everybody! I have postgreslq 7.1 running on a 1 Ghz Intel Box, with 2 H.D. SCSI 10000 RPM connected in a DPT SCSI card with 40 MB cache RAM, 256 Mb RAM and a Intel Mainboard. I have a 2.5 million rows database, and when I do a search using "like" it tooks about a minute to give me a result. What can I do to speed up the answer? reestructurating it is not an option due the kind of data we have... more ram will help? using any kind of index? every suggestion will be welcome... Thanks everybody for your time and support! Greetings from Lima - Peru! Jorge Luis Sarmiento System Administrator Lima's Chamber of Commerce www.e-camara.net P.D. Sorry for my bad English ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
