Re: How to improve the database performance

Hi,

Ing. Yusniel Hidalgo Delgado wrote:
> 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?.

Can you please give more information?

Do you want to improve crawling/indexing performance or search performance?

What is your database statistics? What does "indexer -S" return for you?

> In 
> Postgresql is posible create index for each table, it is recomended for 
> mnogosearch database?

mnoGoSearch table structure already has indexes.

> 2- Is recomended execute the following commands in this order?
> indexer
> indexer -R
> indexer -Eblob
> indexer -Ewordstat

Yes, this will give the full package,
popularity rank, search index itself,
and misspelled words suggestions.

The order is exactly correct.
Popularity rank should be calculated before "indexer -Eblob",
while word statistics for misspelled suggestion - after
"indexer -Eblob".


> 
> 3- Someone have a small script in bash shell with these commands?.

There's no shell such script in the distribution.
You can put the above commands into an own written script.

> 
> 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
> --------------------------------------------------------------------------------------------