PostgreSQL Topics

Full Text Search

• Official Documentation
• pg_trgm - Trigram matching
• PGroonga - Multilingual Full Text Search
• Speeding up LIKE '%text%' queries

Limitations:

• Lexeme length < 2KB
• tsvector length < 1MB
• Nodes in tsquery < 32,768

GIN Index

• Documentation
• Built-in Opclasses

Name	Indexed Data Type	Operators
array_ops	anyarray	&&, <@, =, @>
jsonb_ops	jsonb	?, ?&, ?|, @>
jsonb_path_ops	jsonb	@>
tsvector_ops	tsvector	@@, @@@

Analytics

• 10 Reasons to Start Your Analytics Project with PostgreSQL
• Real-Time Analytics with Citus
• 2UDA - Unified Data Analytics

Parallel Query

• Parallel Query Docs
  • Scans, Joins, Aggregation