X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/c3e8a2efd2c9adfc767479112051435849328502..121ef82e2c8ad79bfc8dc06249e162c8a2f4e857:/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 #