Articles in indexing

Indexing for full text search in PostgreSQL

Do you have textual content in PostgreSQL that you'd like to be able to search more effectively, but you're not sure you're ready to implement a full-blown search application like Lucene, SOLR, or Elasticsearch? The full text search functionality in…

Continue reading »

MongoDB Indexing Best Practices

Going “Best Practice” on any topic is an expansive statement. But, we will give it a go with some high level anti-patterns and best practices. Some best practices will be general statements about the performance of MongoDB. Indexing Constraints The f…

Continue reading »