How to improve the database performance
"Ing. Yusniel Hidalgo Delgado" <[email protected]>
| Newsgroups | gmane.comp.web.mnogosearch.general |
|---|---|
| Message-ID | <[email protected]> |
Hi, I have Postgresql 8.4 and Mnogosearch 3.3.10 (latest release) installed and working. I need help about the following questions: 1- How to improve the index performance in Postgresql 8.4?. In Postgresql is posible create index for each table, it is recomended for mnogosearch database? 2- Is recomended execute the following commands in this order? indexer indexer -R indexer -Eblob indexer -Ewordstat 3- Someone have a small script in bash shell with these commands?. Thanks for your time. -- -------------------------------------------------------------------------------------------- Ing. Yusniel Hidalgo Delgado Product Development Department. CEIGE University of Informatic Sciences http://www.uci.cu/ Personal Blog: http://facultad3.uci.cu/dragoblogs/dragotux/ Linux User # 438033 --------------------------------------------------------------------------------------------