Fix for slow GIN index queries when "gin_fuzzy_search_limit" setting is relatively small for large tables

Title

Topic

Bug Fixes

Created

2020-02-09 21:11:47

Last modified

2020-04-03 17:16:14 (4 years, 7 months ago)

Latest email

2020-04-04 00:38:50 (4 years, 7 months ago)

Status

2020-03: Committed

Target version

Authors

Ade Heyward (wizeird)

Reviewers

Committer

Tom Lane (tgl)

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2442
git checkout commitfest/cf/2442

Emails

[PATCH] Fix for slow GIN index queries when "gin_fuzzy_search_limit" setting is relatively small for large tables: First at 2020-02-02 18:06:01 by Adé <ade.hey at gmail.com>
Latest at 2020-04-04 00:38:50 by Adé <ade.hey at gmail.com>
Latest attachment (gin-fuzzy-search-limit-fix-2.patch) at 2020-04-02 23:18:29 from Tom Lane <tgl at sss.pgh.pa.us>
Attachment (gin-fuzzy-search-limit-fix-2.patch) at 2020-04-02 23:18:29 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
Attachment (gin_fuzzy_search_limit_test.sql) at 2020-02-02 18:06:01 from Adé <ade.hey at gmail.com> (Patch: No)

History

When	Who	What
2020-04-03 17:16:14	Tom Lane (tgl)	Closed in commitfest 2020-03 with status: Committed
2020-04-03 17:16:14	Tom Lane (tgl)	Changed committer to tgl
2020-04-02 22:56:43	Tom Lane (tgl)	Added tgl as reviewer
2020-03-10 23:23:03	Tom Lane (tgl)	Changed authors to Ade Heyward (wizeird)
2020-02-09 21:11:47	Ade Heyward (wizeird)	Attached mail thread CAEknJCdS-dE1Heddptm7ay2xTbSeADbkaQ8bU2AXRCVC2LdtKQ@mail.gmail.com
2020-02-09 21:11:47	Ade Heyward (wizeird)	Created patch record