| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Update docs for GIN index improvements |
| Date: | 2015-05-16 12:37:59 |
| Message-ID: | 20150516123759.GB16100@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
We have made major improvements in GIN in the past few releases,
particularly 9.4, but the full text search docs recommending when to use
GIN and GiST indexes have not been updated. This blog post empirically
shows many of the improvements:
http://blog.pgaddict.com/posts/performance-since-postgresql-7-4-to-9-4-fulltext
I would like to apply the attached patch to 9.5 to recommend GIN indexes
for full text search, and remove mention of many old GIN limitations.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
| Attachment | Content-Type | Size |
|---|---|---|
| gin.diff | text/x-diff | 7.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2015-05-20 03:02:11 | backup.sgml WIP (patch included) |
| Previous Message | Amit Langote | 2015-05-15 07:22:42 | Link section in custom scan documentation |