Telegram Group & Telegram Channel
Π§ΡƒΡ‚ΡŒ Π±ΠΎΠ»Π΅Π΅ дСсятка ΠΏΠΎΠ»Π΅Π·Π½Ρ‹Ρ… запросов для Postgres собрал ΠΈ ΠΎΡ„ΠΎΡ€ΠΌΠΈΠ» с ΠΏΡ€ΠΈΠΌΠ΅Ρ€Π°ΠΌΠΈ. Для ΠΎΠ΄Π½ΠΎΠ³ΠΎ поста Π² Ρ‚Π΅Π»Π΅Π³Ρƒ - это слишком ΠΌΠ½ΠΎΠ³ΠΎ (особСнно с Ρ€Π°Π·ΠΌΠ΅Ρ‚ΠΊΠΎΠΉ ΠΏΡ€ΠΈΠΌΠ΅Ρ€ΠΎΠ² Π²Ρ‹Π²ΠΎΠ΄Π°). Π’Π°ΠΊ Ρ‡Ρ‚ΠΎ ΠΏΠΎΠ»ΠΎΠΆΠΈΠ» Π² Π²ΠΈΠ΄Π΅ gist Π½Π° github:
πŸ”ΈΠ’Π΅ΠΊΡƒΡ‰ΠΈΠ΅ выполняСмыС запросы
πŸ”ΈΠ—Π°ΠΏΡ€ΠΎΡΡ‹, выполняСмыС Π±ΠΎΠ»Π΅Π΅ 1 сСкунды
πŸ”ΈΠ’Π°Π±Π»ΠΈΡ†Ρ‹ с % попадания Π² кэш ΠΏΡ€ΠΈ ΠΈΡ… использовании
πŸ”ΈΠ Π°Π·ΠΌΠ΅Ρ€Ρ‹ Ρ‚Π°Π±Π»ΠΈΡ† (Π²ΠΊΠ»ΡŽΡ‡Π°Ρ индСксы)
πŸ”ΈΠ Π°Π·ΠΌΠ΅Ρ€Ρ‹ индСксов
πŸ”ΈΠ Π°Π·ΠΌΠ΅Ρ€ Ρ‚Π΅ΠΊΡƒΡ‰Π΅ΠΉ Π‘Π”
πŸ”ΈΠ Π°Π·ΠΌΠ΅Ρ€Ρ‹ ΠΈ Π½Π°Π»ΠΈΡ‡ΠΈΠ΅ Π²Ρ€Π΅ΠΌΠ΅Π½Π½Ρ‹Ρ… Ρ„Π°ΠΉΠ»ΠΎΠ²
πŸ”ΈΠ‘Ρ‚Π°Ρ‚ΠΈΡΡ‚ΠΈΠΊΠ° ΠΏΠΎ Ρ‡Ρ‚Π΅Π½ΠΈΡŽ индСксов
πŸ”ΈΠ‘Ρ‚Π°Ρ‚ΠΈΡΡ‚ΠΈΠΊΠ° использования индСксов
πŸ”ΈΠ’ΠΎΠΏ 5 самых Π°ΠΊΡ‚ΠΈΠ²Π½Ρ‹Ρ… Ρ‚Π°Π±Π»ΠΈΡ†
πŸ”ΈΠ’ΠΎΠΏ 5 самых Π°ΠΊΡ‚ΠΈΠ²Π½Ρ‹Ρ… индСксов
πŸ”ΈΠΠΈΠΊΠΎΠ³Π΄Π° Π½Π΅ ΠΈΡΠΏΠΎΠ»ΡŒΠ·ΠΎΠ²Π°Π½Π½Ρ‹Π΅ индСксы
#postgres



tg-me.com/notes_of_programmer/466
Create:
Last Update:

Π§ΡƒΡ‚ΡŒ Π±ΠΎΠ»Π΅Π΅ дСсятка ΠΏΠΎΠ»Π΅Π·Π½Ρ‹Ρ… запросов для Postgres собрал ΠΈ ΠΎΡ„ΠΎΡ€ΠΌΠΈΠ» с ΠΏΡ€ΠΈΠΌΠ΅Ρ€Π°ΠΌΠΈ. Для ΠΎΠ΄Π½ΠΎΠ³ΠΎ поста Π² Ρ‚Π΅Π»Π΅Π³Ρƒ - это слишком ΠΌΠ½ΠΎΠ³ΠΎ (особСнно с Ρ€Π°Π·ΠΌΠ΅Ρ‚ΠΊΠΎΠΉ ΠΏΡ€ΠΈΠΌΠ΅Ρ€ΠΎΠ² Π²Ρ‹Π²ΠΎΠ΄Π°). Π’Π°ΠΊ Ρ‡Ρ‚ΠΎ ΠΏΠΎΠ»ΠΎΠΆΠΈΠ» Π² Π²ΠΈΠ΄Π΅ gist Π½Π° github:
πŸ”ΈΠ’Π΅ΠΊΡƒΡ‰ΠΈΠ΅ выполняСмыС запросы
πŸ”ΈΠ—Π°ΠΏΡ€ΠΎΡΡ‹, выполняСмыС Π±ΠΎΠ»Π΅Π΅ 1 сСкунды
πŸ”ΈΠ’Π°Π±Π»ΠΈΡ†Ρ‹ с % попадания Π² кэш ΠΏΡ€ΠΈ ΠΈΡ… использовании
πŸ”ΈΠ Π°Π·ΠΌΠ΅Ρ€Ρ‹ Ρ‚Π°Π±Π»ΠΈΡ† (Π²ΠΊΠ»ΡŽΡ‡Π°Ρ индСксы)
πŸ”ΈΠ Π°Π·ΠΌΠ΅Ρ€Ρ‹ индСксов
πŸ”ΈΠ Π°Π·ΠΌΠ΅Ρ€ Ρ‚Π΅ΠΊΡƒΡ‰Π΅ΠΉ Π‘Π”
πŸ”ΈΠ Π°Π·ΠΌΠ΅Ρ€Ρ‹ ΠΈ Π½Π°Π»ΠΈΡ‡ΠΈΠ΅ Π²Ρ€Π΅ΠΌΠ΅Π½Π½Ρ‹Ρ… Ρ„Π°ΠΉΠ»ΠΎΠ²
πŸ”ΈΠ‘Ρ‚Π°Ρ‚ΠΈΡΡ‚ΠΈΠΊΠ° ΠΏΠΎ Ρ‡Ρ‚Π΅Π½ΠΈΡŽ индСксов
πŸ”ΈΠ‘Ρ‚Π°Ρ‚ΠΈΡΡ‚ΠΈΠΊΠ° использования индСксов
πŸ”ΈΠ’ΠΎΠΏ 5 самых Π°ΠΊΡ‚ΠΈΠ²Π½Ρ‹Ρ… Ρ‚Π°Π±Π»ΠΈΡ†
πŸ”ΈΠ’ΠΎΠΏ 5 самых Π°ΠΊΡ‚ΠΈΠ²Π½Ρ‹Ρ… индСксов
πŸ”ΈΠΠΈΠΊΠΎΠ³Π΄Π° Π½Π΅ ΠΈΡΠΏΠΎΠ»ΡŒΠ·ΠΎΠ²Π°Π½Π½Ρ‹Π΅ индСксы
#postgres

BY πŸ““ Записки ΠΏΡ€ΠΎΠ³Ρ€Π°ΠΌΠΌΠ΅Ρ€Π°


Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/notes_of_programmer/466

View MORE
Open in Telegram


telegram Telegram | DID YOU KNOW?

Date: |

Telegram and Signal Havens for Right-Wing Extremists

Since the violent storming of Capitol Hill and subsequent ban of former U.S. President Donald Trump from Facebook and Twitter, the removal of Parler from Amazon’s servers, and the de-platforming of incendiary right-wing content, messaging services Telegram and Signal have seen a deluge of new users. In January alone, Telegram reported 90 million new accounts. Its founder, Pavel Durov, described this as β€œthe largest digital migration in human history.” Signal reportedly doubled its user base to 40 million people and became the most downloaded app in 70 countries. The two services rely on encryption to protect the privacy of user communication, which has made them popular with protesters seeking to conceal their identities against repressive governments in places like Belarus, Hong Kong, and Iran. But the same encryption technology has also made them a favored communication tool for criminals and terrorist groups, including al Qaeda and the Islamic State.

Telegram Gives Up On Crypto Blockchain Project

Durov said on his Telegram channel today that the two and a half year blockchain and crypto project has been put to sleep. Ironically, after leaving Russia because the government wanted his encryption keys to his social media firm, Durov’s cryptocurrency idea lost steam because of a U.S. court. β€œThe technology we created allowed for an open, free, decentralized exchange of value and ideas. TON had the potential to revolutionize how people store and transfer funds and information,” he wrote on his channel. β€œUnfortunately, a U.S. court stopped TON from happening.”

telegram from nl


Telegram πŸ““ Записки ΠΏΡ€ΠΎΠ³Ρ€Π°ΠΌΠΌΠ΅Ρ€Π°
FROM USA