O'Reilly logo

Troubleshooting PostgreSQL by Hans-Jürgen Schönig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Fixing full-text search

After focusing on some highly important and common problems related to indexing, it is time to discuss the most important pitfalls in the area of full-text indexing.

Not using full-text search at all

One of the most common mistakes made is not to use full-text search at all. Many people tend to use LIKE instead of proper, PostgreSQL-style full-text searching. Doing that can open a Pandora's box and result in various performance issues.

To demonstrate the point, some sample text can be loaded. In this case, Shakespeare's Hamlet has been selected, which can be downloaded freely from www.gutenberg.org (an archive of free books). To load the data, end users can turn to curl, just as was shown before in the previous example. PostgreSQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required