BloGroonga

2023-03-27

PGroonga (fast full text search module for PostgreSQL) 2.4.7 has been released

PGroonga 2.4.7 has been released! PGroonga makes PostgreSQL fast full text search for all languages.

Highlight

  • Fixed a bug that PGroonga crashed when we set PGroonga's index against a column of UUID type.

How to upgrade

This version is compatible with before versions. You can upgrade by steps in "Compatible case" in Upgrade document.

Conclusion

If you are new user, see also About PGroonga.

Try PGroonga when you want to perform fast full text search against all languages on PostgreSQL!

2023-03-24

PGroonga (fast full text search module for PostgreSQL) 2.4.6 has been released

PGroonga 2.4.6 has been released! PGroonga makes PostgreSQL fast full text search for all languages.

Highlight

  • &^ operator Added support for pgroonga_full_text_search_condition.

    We can use the same search options specified in PGroonga index in sequential search by using the following syntax.

    column &^ (prefix, NULL, index_name)::pgroonga_full_text_search_condition
    
  • &= operator Added a newly operator &=.

    &= operator performs exact match search. We can use the same search options specified in PGroonga index in sequential search. Because &= operator supports the following syntax.

    column &= (keyword, NULL, index_name)::pgroonga_full_text_search_condition
    

How to upgrade

This version is compatible with before versions. You can upgrade by steps in "Compatible case" in Upgrade document.

Conclusion

If you are new user, see also About PGroonga.

Try PGroonga when you want to perform fast full text search against all languages on PostgreSQL!

2023-03-24

Groonga 13.0.1 has been released

Groonga 13.0.1 has been released!

How to install: Install

Changes

Here are important changes in this release:

Improvements

  • Normalizers Added a new options for NormalizerNFKC*.

    We added the following options. We can use these options in all NormalizerNFKC. Please refer NormalizerNFKC150 about the detail of these options.

    • unify_kana_prolonged_sound_mark
    • unify_kana_hyphen
    • unify_katakana_trailing_o
  • Add support for MessagePack v6.0.0.

    Groonga can not found MessagePack v6.0.0 or later when we execute configure or cmake until now. Groonga can found MessagePack since this release even if the version of MessagePack is v6.0.0 or later.

Fixes

  • highlight_html Fixed a bug that highlight position may move over when we use loose_symbol=true.

  • Normalizers Fixed a bug that NormalizerNFKC* did incorrect normalization.

    This bug occured when unify_kana_case and unify_katakana_v_sounds used at the same time.

    For example, ヴァ was normalized to バア with unify_kana_case and unify_katakana_v_sounds, but ヴァ should be normalized to .

    This was because ヴァ was normalized to ヴア with unify_kana_case, and after that, ヴア was normalized to バア with unify_katakana_v_sounds. We fixed to normalize characters with unify_katakana_v_sounds before unify_kana_case.

    Here is an example of the bug in the previous version.

    normalize \
    'NormalizerNFKC150("unify_katakana_v_sounds", true, \
                      "unify_kana_case", true)' \
    "ヴァーチャル"
    #[
    #  [
    #    0,
    #    1678097412.913053,
    #    0.00019073486328125
    #  ],
    #  {
    #    "normalized":"ブアーチヤル",
    #    "types":[],
    #    "checks":[]
    #  }
    

    From this version, ヴァーチャル is normalized to バーチヤル.

Known Issues

  • Currently, Groonga has a bug that there is possible that data is corrupt when we execute many additions, delete, and update data to vector column.

  • *< and *> only valid when we use query() the right side of filter condition.

    If we specify as below, *< and *> work as &&.

    • 'content @ "Groonga" *< content @ "Mroonga"'
  • Groonga may not return records that should match caused by GRN_II_CURSOR_SET_MIN_ENABLE.

Conclusion

Please refert to the following news for more details.

News Release 13.0.1

Let's search by Groonga!

2023-03-06

PGroonga (fast full text search module for PostgreSQL) 2.4.5 has been released

PGroonga 2.4.5 has been released! PGroonga makes PostgreSQL fast full text search for all languages.

Highlight

[Crash safe] Fixed a bug that re-index recovery doesn't work when the crash safe module failed recovery using Groonga's WAL.

The crash safe module writes Groonga's WAL (not PostgreSQL's WAL) when PGroonga's indexes are updated. It ensure flushing WAL to storage.

The crash safe module recovers the database automatically. The crash safe module tries recovering from Groonga's WAL. If it's failed, the crash safe module removes all existing Groonga's database, creates a new Groonga's database and executes REINDEX. It rebuild all PGroonga's indexes from data in PostgreSQL.

This problem The crash safe module re-index doesn't work when the crash safe module failed recovery using Groonga's WAL.

How to upgrade

This version is compatible with before versions. You can upgrade by steps in "Compatible case" in Upgrade document.

Conclusion

If you are new user, see also About PGroonga.

Try PGroonga when you want to perform fast full text search against all languages on PostgreSQL!