Making a Postgres query 1,000 times faster
Mattermost uses Elasticsearch in large deployments to reduce the stress the database suffers when running search queries while returning even better, fine-tuned results. For this to work, Elasticsearch needs to index all data we want to search for, so that it can retrieve it quickly when requested. Once the data is indexed, all works as expected, our users are happy, our developers are happy, and life is good.
However, I recently tested something I haven’t tried in a while: indexing a fairly lar...
Read more at mattermost.com