X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/d8fb371d54ff464bbd45186b5848f6a9f9d87d5e..9a1ba12c81f7c79c362e36f14ed7955f5765e833:/app/models/note.rb diff --git a/app/models/note.rb b/app/models/note.rb index 068efa59a..6a83b6b01 100644 --- a/app/models/note.rb +++ b/app/models/note.rb @@ -16,10 +16,11 @@ # # Indexes # -# index_notes_on_description (to_tsvector('english'::regconfig, description)) USING gin -# notes_created_at_idx (created_at) -# notes_tile_status_idx (tile,status) -# notes_updated_at_idx (updated_at) +# index_notes_on_description (to_tsvector('english'::regconfig, description)) USING gin +# index_notes_on_user_id_and_created_at (user_id,created_at) WHERE (user_id IS NOT NULL) +# notes_created_at_idx (created_at) +# notes_tile_status_idx (tile,status) +# notes_updated_at_idx (updated_at) # # Foreign Keys #