# tsearch

Published articles for tsearch.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Polish configuration for TSearch

DevFeed: [Polish configuration for TSearch](<https://devfeed.tech/articles/polish-configuration-for-tsearch-33688.md>)

Original publisher: [Read original article](<https://www.depesz.com/2026/04/21/polish-configuration-for-tsearch/>)

Author: depesz

Published: 2026-04-21T21:06:13Z

Content type: tutorial

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [configuration](<https://devfeed.tech/topics/configuration.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Linux](<https://devfeed.tech/topics/linux.md>), [Debian](<https://devfeed.tech/topics/debian.md>), [postgresql 18](<https://devfeed.tech/topics/postgresql-18.md>), [releases](<https://devfeed.tech/topics/releases.md>)

Tags: [configuration](<https://devfeed.tech/tags/configuration.md>), [debian](<https://devfeed.tech/tags/debian.md>), [howto](<https://devfeed.tech/tags/howto.md>), [hunspell](<https://devfeed.tech/tags/hunspell.md>), [ispell](<https://devfeed.tech/tags/ispell.md>), [linux](<https://devfeed.tech/tags/linux.md>), [pl-pl](<https://devfeed.tech/tags/pl-pl.md>), [polish](<https://devfeed.tech/tags/polish.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [releases](<https://devfeed.tech/tags/releases.md>), [sql](<https://devfeed.tech/tags/sql.md>), [tsearch](<https://devfeed.tech/tags/tsearch.md>), [tutorial](<https://devfeed.tech/tags/tutorial.md>), [ubuntu](<https://devfeed.tech/tags/ubuntu.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

This tutorial explains how to configure Polish full-text search in PostgreSQL. It reports that PostgreSQL 19 is expected to include a Polish dictionary, while current PostgreSQL versions such as PostgreSQL 18 require installing or obtaining Hunspell Polish files, converting them to UTF-8 when necessary, placing them in the PostgreSQL text-search data directory, and configuring and testing the dictionary.

### Source excerpt

Some time ago someone posted on Reddit that they have problems adding Polish configuration to their PostgreSQL. While checking it, I found some interesting news. And of course figured out how to have Polish configuration... First, the news: apparently in PostgreSQL 19, we will automatically get Polish dictionary, thanks to this commit from 5th of ... Continue reading "Polish configuration for TSearch"

## Do you really need tsvector column?

DevFeed: [Do you really need tsvector column?](<https://devfeed.tech/articles/do-you-really-need-tsvector-column-33668.md>)

Original publisher: [Read original article](<https://www.depesz.com/2025/11/03/do-you-really-need-tsvector-column/>)

Author: depesz

Published: 2025-11-03T12:34:33Z

Content type: article

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [Algorithm](<https://devfeed.tech/topics/algorithm.md>)

Tags: [algorithm](<https://devfeed.tech/tags/algorithm.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [comparison](<https://devfeed.tech/tags/comparison.md>), [data](<https://devfeed.tech/tags/data.md>), [function](<https://devfeed.tech/tags/function.md>), [gin](<https://devfeed.tech/tags/gin.md>), [gist](<https://devfeed.tech/tags/gist.md>), [index](<https://devfeed.tech/tags/index.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [query](<https://devfeed.tech/tags/query.md>), [tsearch](<https://devfeed.tech/tags/tsearch.md>), [tsvector](<https://devfeed.tech/tags/tsvector.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

This article tests whether a materialized tsvector column is necessary for full-text search. Using a large Wikipedia-derived dataset, it compares a tsvector column with an expression-based function index and reports that the tested query took about 4.5 minutes with the materialized column versus almost an hour with the function-based index.

### Source excerpt

When using tsearch one usually, often, creates a tsvector column to put data in, and then create index on it. But, do you really need the index? I wrote once already that you don't have to, but then a person talked with me on IRC, and pointed this section of docs: One advantage of the ... Continue reading "Do you really need tsvector column?"