PostgreSQL Topics
约 1 分钟阅读
Full Text Search
- Official Documentation
- pg_trgm - Trigram matching
- PGroonga - Multilingual Full Text Search
- Speeding up LIKE '%text%' queries
Limitations:
- Lexeme length < 2KB
tsvectorlength < 1MB- Nodes in
tsquery< 32,768
GIN Index
| 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
关联信息
反向链接、本文链接的其他页面和外部资料。
参考资料
其他外链10 条
- 0x80.pl/articles/sql-ngram-index.html0x80.pl/articles/sql-ngram-index.html
- dzone.com/articles/building-real-time-analytics-dashboards-with-postgdzone.com/articles/building-real-time-analytics-dashboards-with-postg
- pgroonga.github.iopgroonga.github.io/
- www.2ndquadrant.com/en/resources/2udawww.2ndquadrant.com/en/resources/2uda
- www.postgresql.org/docs/current/static/gin-builtin-opclasses.htmlwww.postgresql.org/docs/current/static/gin-builtin-opclasses.html
- www.postgresql.org/docs/current/static/gin.htmlwww.postgresql.org/docs/current/static/gin.html
- www.postgresql.org/docs/current/static/parallel-query.htmlwww.postgresql.org/docs/current/static/parallel-query.html
- www.postgresql.org/docs/current/static/pgtrgm.htmlwww.postgresql.org/docs/current/static/pgtrgm.html
- www.postgresql.org/docs/current/static/textsearch.htmlwww.postgresql.org/docs/current/static/textsearch.html
- www.slideshare.net/snaga/10-reasons-to-start-your-analytics-project-with-postgresqlwww.slideshare.net/snaga/10-reasons-to-start-your-analytics-project-with-postgresql