Один % убил мой индекс — поиск завис на 8 секунд 🔥 LIKE '%foo%' — это ловушка: процент в начале выключает индекс. На миллионе строк — 5 мс против 8 сек. #sql #postgres #postgresql #backend #python #django #программирование #разработка #databases #performance #sqlacademy

China has welcomed the agreement reached between the US and Iran to end their conflict and reopen the Strait of Hormuz. Foreign Ministry spokesperson Lin Jian said Beijing hopes the first-phase memorandum of understanding will be signed as scheduled and called on all parties to choose peace and resolve differences through dialogue. Lin also said China hopes security and free passage through the Strait of Hormuz can be restored as soon as possible, describing stability in the vital shipping route

Brother Meets Sister After 10 Years ❤️#BrotherSisterLove#SiblingReunion#FamilyLove#EmotionalMoment

England fans are asked to leave a bar in Dallas by police, ahead of World Cup match against Croatia