diff options
| author | rinpatch <rinpatch@sdf.org> | 2019-05-22 11:56:53 +0300 |
|---|---|---|
| committer | rinpatch <rinpatch@sdf.org> | 2019-05-22 11:56:53 +0300 |
| commit | 10ca1f91de12c3ff3a1adff2cf36e9ec47c659dd (patch) | |
| tree | cbf0f678708587e11616016fceb17fdeba1984cc | |
| parent | 63b0b7190cb652cd27d236e3f9daaaf5e50701a6 (diff) | |
| download | pleroma-10ca1f91de12c3ff3a1adff2cf36e9ec47c659dd.tar.gz pleroma-10ca1f91de12c3ff3a1adff2cf36e9ec47c659dd.zip | |
Add GIN index on object data->'name'
| -rw-r--r-- | priv/repo/migrations/20190522084924_add_object_index_on_name.exs | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/priv/repo/migrations/20190522084924_add_object_index_on_name.exs b/priv/repo/migrations/20190522084924_add_object_index_on_name.exs new file mode 100644 index 000000000..886e8499e --- /dev/null +++ b/priv/repo/migrations/20190522084924_add_object_index_on_name.exs @@ -0,0 +1,7 @@ +defmodule Pleroma.Repo.Migrations.AddObjectIndexOnName do + use Ecto.Migration + + def change do + create(index(:objects, ["(data->'name')"], name: :objects_name_index, using: :gin)) + end +end |