Skip to content

History / Building indexes

Revisions

  • Updated Building indexes (markdown)

    @phil-janeapp phil-janeapp committed Feb 21, 2024
  • Updated Building indexes (markdown)

    @phil-janeapp phil-janeapp committed Feb 21, 2024
  • Colorize ruby code examples

    @biow0lf biow0lf committed Sep 13, 2021
  • add link to blog post about multi-column indexes https://github.com/Casecommons/pg_search/issues/475

    @jjb jjb committed Sep 4, 2021
  • Updated Building indexes (markdown)

    @framallo framallo committed Apr 6, 2021
  • A typo? Operator class pg_trgm_ops does not exist. It should say: "gist_trgm_ops"

    @maximbond maximbond committed May 2, 2020
  • Add note about index having to match all the fields at pg_search_scope

    @gnclmorais gnclmorais committed Mar 26, 2020
  • Update the example pg_search_documents index to show the example for trigram indexes

    @copiousfreetime copiousfreetime committed Mar 10, 2020
  • Updated Building indexes (markdown)

    @eliotsykes eliotsykes committed Jul 5, 2019
  • Add docs on migration to generate index for pg_search_documents

    @eliotsykes eliotsykes committed Jul 5, 2019
  • Formatting to clarify are 2 alternative options.

    @eliotsykes eliotsykes committed Jul 5, 2019
  • Updated Building indexes (markdown)

    @f6v f6v committed Jul 1, 2019
  • Updated Building indexes (markdown)

    Tom Smyth committed Sep 11, 2017
  • Added hint to check EXPLAIN

    Tom Smyth committed Sep 11, 2017
  • Added instructions for adding to search specification.

    Tom Smyth committed Sep 11, 2017
  • Added more efficient way to update existing records.

    Tom Smyth committed Sep 11, 2017
  • tsvector_update_trigger returns a trigger which must be used directly in a create trigger sql statement. Since hair_trigger wraps the trigger code in it's own function this doesn't work. A custom tsv update trigger can be used however, the simplest of which I believe is the one now listed here. For more information: http://stackoverflow.com/questions/21147893/tsvector-update-trigger-cant-find-tsvector-column/21156826#21156826 . Also clarify what exactly you're adding the index to.

    @dnjstrom dnjstrom committed Jan 16, 2014
  • Change 'you need enough columns for the index to be used' to 'rows'

    @LukasSkywalker LukasSkywalker committed Dec 15, 2013
  • Updated Building indexes (markdown)

    @morgoth morgoth committed Dec 12, 2013
  • Updated Building indexes (markdown)

    @morgoth morgoth committed Dec 12, 2013
  • Added `new.tsv := ` in the manual trigger

    @apraditya apraditya committed Nov 28, 2013
  • Updated Building indexes (markdown)

    @nertzy nertzy committed Sep 13, 2013
  • Fix formatting.

    Steven Harman committed Aug 4, 2013
  • Add instructions for Rails

    Steven Harman committed Aug 4, 2013
  • Updated Building indexes (markdown)

    @nertzy nertzy committed May 19, 2013
  • Write a rough stub article. It needs work!

    @nertzy nertzy committed May 19, 2013