I’m building an e-commerce website and using PostgreSQL as my database. I need to implement a search feature that allows users to search for products efficiently. I’m also planning to support the Myanmar language which uses a complex script and does not have clear word boundaries like spaces in Latin scripts, for product descriptions and search queries. To enhance the search functionality, I’m considering integrating a search engine like Elasticsearch or other solutions.

I have tried using pg_search with PostgreSQL, but I want to ensure I’m using the most effective and scalable solution, especially for an e-commerce website that will grow in terms of product catalog and language support.

Can anyone recommend the best practices for integrating a search engine with PostgreSQL in this context, particularly for handling multiple languages, including Myanmar?

I’ve implemented full-text search using PostgreSQL’s built-in tsvector and tsquery functions for product descriptions, but it’s not performing well as the number of products increases.
What I am looking for is –
Best practices and recommendations for integrating a search engine with PostgreSQL for an e-commerce site.
Suggestions for scalable and efficient search solutions, especially for handling the Myanmar language.
Resources (e.g., tutorials, blog posts, books, etc.) that could help me with this implementation.