How-to: Create an FTS index

Before this module can be of any use, you will have to create a FTS index of your desired field data (see chapter "What is indexing" for more information about indexing itself). This chapter is a step-by-step guide on how to create a FTS index.

First navigate to the main overview page of this module: admin/config/search/postgresql-fts, then click on "+ Add a FTS index":

Add a FTS index

What is indexing

From text to lexemes

In this chapter I will explain what "indexing" is within a PostgreSQL full text search setting and how this module goes about creating such a "FTS index".

As said on the introduction page, a full text solution most convert your passages of text (field data in our case) into something else in order for it to perform full text searches. This "something else" in PostgreSQL is called a tsvector - a data type specially designed to hold processed lexemes.

What are lexemes?

PostgreSQL Full Text Search

This is the main (end-user) documentation for the PostgreSQL Full Text Search module, explaining how this module works, how to setup and manage your FTS indexes, how to manage your database indexes and how to use Views to leverage the power of full text within your Drupal installation.

Note: Since the module is still in early stages of development, consider these pages to shift as new features are added, bugs are fixed or simply functionality is optimized.

Before we dive into a hands-on approach, a bit of background:

Using Drupal (3rd Edition)

Choosing and Configuring Modules to Build Dynamic Websites
O'Reilly Media
Publication date: 
Page count: 

Take advantage of Drupal’s vast collection of community-contributed modules and discover how they make this web framework unique and valuable. With this guide, you’ll learn how to combine modules in interesting ways (with minimal code-wrangling) to develop several community-driven websites.

The third edition focuses on Drupal 8, the latest version of this open source system. Each project spans an entire chapter, with step-by-step "recipes" to help you build out the precise functionality the site requires. With this book, developers new to Drupal will gain experience through a hands-on introduction, and experienced Drupal developers will learn real-world best practices.

Enterprise Drupal

Emerging Best Practices for Large Scale Drupal

Django Beatty
Rob Knight

O'Reilly Media
Publication date: 
Page count: 

Drupal is not only a valuable CMS for bloggers and hobbyists, but it is also an increasingly common option for enterprise use—including transactional applications as well as those for publishing and social purposes. In this practical book, author Django Beatty covers a wide range of Drupal topics for enterprise customers, and provides solutions and answers to common questions that CTOs, architects, and development leads have when using Drupal at scale.

Organizations typically make mistakes when adopting any new technology. This book minimizes the pain through the lessons that other enterprise users have learned. You’ll learn how to leverage Drupal’s modular based architecture, scalability, flexibility, and cost savings.

  • Get up to speed on Drupal’s architecture and learn how it fits within a wider enterprise solution
  • Focus on mobile solutions and the emergence of omni-channel approaches to content
  • Learn key features, including decoupled or "headless" Drupal (both as a services-based component and as an orchestration layer itself)
  • Understand typical enterprise anti-patterns when adopting Drupal and get approaches to mitigate them

Search Engine Optimization Modules

Drupal offers many features for search engine optimization. This document provides a list of features that are often used and a brief explanation of each.


Subscribe with RSS Subscribe to RSS - Site administrators