Postgres FTS
www.postgresql.org- Category
- Developer Tools
- Rank
- No. 1348Tools index
Previous survey · No. 1312 ·
- Pricing
- Open Source
- Type
- TOOL
- Date
About
Built-in full-text search in Postgres. Postgres' built-in full-text search via tsvector/tsquery. Great for small-to-mid scale apps that already use Postgres — no extra service to run.
What it does
The site presents this as a manual chapter of the official PostgreSQL documentation, covering how text gets parsed into a searchable form, matched against queries, ranked, and highlighted, with configurable dictionaries and index types handled inside the database engine itself.
Stated on the product site
- Documentation structure
- The chapter is organized as a dedicated section on dictionaries within the full text search manual.
- Dictionary types
- Multiple named dictionary types are documented as separate subsections, including simple, synonym, thesaurus, Ispell, and Snowball dictionaries.
- Indexing guidance
- The manual has a dedicated section recommending which index types to use for text search.
- Interface support
- The documentation includes a section specifically on psql support for this feature.
Not stated on the site
- The page does not state pricing or licensing terms for using this feature.
- Performance characteristics or scalability limits compared to other search approaches are not described on this page.
- How this feature compares to dedicated external search engines is not addressed here.
- The page does not describe setup steps or configuration examples beyond listing that a configuration example section exists.
Written from the product site at postgresql.org.
Tags
PostgreSQLSearch
Media
Comments (0)
No comments yet
Editorially curated, with community endorsements as a secondary signal. Corrections welcome.