Search⌘ K
Home
Courses
The Art of PostgreSQL

Advanced Tag Indexing

Explore how to use PostgreSQL's intarray extension to handle user-defined tags efficiently. Learn to create materialized views and indexes that support advanced tag queries on datasets like Last.fm tracks, enabling powerful and faster tag-based searches.

We'll cover the following...

Handling user-defined tags can be challenging in SQL when it comes to allowing advanced user queries. To illustrate the point here, we’re going to index and search for Last.fm tracks that are tagged as blues and rhythm and blues.

Using the Last.fm dataset from the Million Song Dataset project provides a dataset that we can reuse that is full of tracks and their user tags.

The intarray extension

PostgreSQL comes with plenty of interesting data ...