PostgreSQLでクエリーを実行した際の内部処理（NestedLoopやSeqScanなど）のOpenTelemetryのスパンを生成してくれるPostgreSQL EXTENSION。おーいいねー。提供元はDatadogだがOTLPなので当然Datadog以外でも活用可。 / “GitHub - DataDog/pg_tracing: Distributed Tracing …” htn.to/4aNLsC86eW

Siapa ngerasa sekarang ngerasa sedang di Nested Loop tanpa Exit? 🎵 MNEMONIKK - Loop No Exit from album: RIOT GRRRL PUNK #Electroclash #riotgrrrl #riotgrrrlpunk #nestedloop youtube.com/shorts/Xx5CB1McO…

Sebuah lagu tentang Nested Loop dan Skrip Politik di tempat kerja .. 🎵 MNEMONIKK - If-Else Do-While (Alternative Version) #Electroclash #nestedloop #loop #politik youtube.com/shorts/kx_ePwNnU…

導出テーブルで絞り込む場合、レコード数が多いと経験的にHashJoinが選択される傾向が強い。一度に数TBのメインメモリが使える環境でなければ、lateral joinでNestedLoop選ばせた方が結果的に安定する気がしてる。

個人的なDBMS実行プラン表示のガバ評価 ※メインで使うのSQLServerなのでバイアスはいってる 　後半文句はいってる… 【S】SQLServer グラフィカルで直感的にわかりやすい テキストやXML表示でめっちゃ詳細まで見れる ライブ統計で進捗も見れていい 情報多すぎ感もあるかも 公式エディタでクエリストアとか機能が充実 【A】Postgresql テキスト表示が見やすい ほしい情報はだいたいある 【うんち】MySQL/MariaDB もっと情報ほしぃ ちょっと古いとNestedLoop地獄 内部構造がシンプルなのでネックがわかりやすい 相関だめマテリアライズしっかり意識 【？】Oracle ほとんど使ったことないし実行プラン見たことない 1DBごとに1インスタンスなのがちょっときらい… クライアントから接続するのにoraファイルいじるのまじなんなん？ 【論外】Software Symfoware 論外

Stake i am down with you, I have been just doing loss and loss, didn't gain a single penny. I want compensation or else I file a case on you 😭😭, just kindding, I am mentally and physically broke 😞😭😭 Help me I'd : Nestedloop

Flow - #ETL #Framework for #PHP just reached another milestone, release 0.8.0! 🚀 I want to say "Thank you, you are amazing!" to all contributors! All contributions, even the smallest ones are pushing that project forward 🤩 The most important changes/fixes: - Filesystem - created from scratch new filesystem abstraction that supports byte reading and chunk writings to/from remote filesystems - Azure Storage SDK - created from scratch, new, lightweight SDK for Azure Storage that depends only on PSR contracts instead of specific implementations of HTTP clients - Azure Storage SDK Filesystem Bridge - integration between our new Azure SDK and our Filesystem Abstraction - Parquet - resolved issues with saving/reading deeply nested empty structures - Parquet - added support for more compression algorithms like BROTLI or LZ4 - Parquet - added support for deprecated CoveredType types - XML - replaced XMLNodeEntry with XMLElementEntry - Core - order entries - Core - Default NestedLoop join algorithm was replaced with HashJoin algorithm - Core - Fixed Cache-based External Sort algorithm implementation and many many more (link to details in comment)

First time I give a shot to daily challenge leetcode problem. • 1st soln pass 35 test cases out of 40 using nestedloop • 2nd soln was using hashmap. But wasn't optimal. • 3rd soln was two pointer approach. And it work better than past solutions. Consistency makes easy⚡

Nemu soal di hackerrank yang sama persis kayak di leetcode, karena di leetcode udah pernah ngerjain pakai metode sliding window, langsung aja implementasi di soal hackerrank tadi. kenapa pakai metode sliding window? karena untuk mengurangi penggunaan nestedloop

If there's already a sorted structure for the inner table, like an index, and not a lot of outer rows, the lookup uses the index for each outer row. This is a #NestedLoop: dbfiddle.uk/neyTH7Hf

നെസ്റ്റഡ് ലൂപ്പിൽ നിന്നും പുറത്തു വരാൻ നെസ്റ്റ് പൊളിക്കേണ്ടി വരുമോ  #loop  #nestedloop

① actual time の多い所に注目 ② loop回数の多いNestedLoopに注目 ③ index絞込みの効率が悪くBitmapScanになってる検索条件 ．．．あたりが、DBチューニングのお手伝いをする際の俺的セオリーかな qiita.com/Kosuke_Kida/items/…

That's a never-ending hand-washing spiral from the beginning of time until the end of time! #nestedloop

Can you figure out how many steps should the duck make? Leave your answer in the comment! #nestedloop #codinggame #STEMeducation #STEMinSchools

Various kind of #loops in #programming #whileloop #forloop #dowhileloop #foreachloop #nestedloop #countloop #dountilloop #infiniteloop #Computerprogramming #Webdevelopment #Developers #Programmers geekboots.com/story/various-…

Because it’s ironic? #NestedLoop

To continue the last lesson,today we learned #forloop and important points like #break and #continue. We worked some interesting example with #forloop and #nestedloop. @CodeToInspire @a_daneshyar #afghangirlscode #Java

.@SCSatCMU Intro to DB Systems #11 ➜ Sorting & Joins [NestedLoop, SortMerge] (VID:youtube.com/watch?v=OIT9Y1IB… ◇ PDF:15445.courses.cs.cmu.edu/fal…)

4th grade geniuses #collaborating on solving a #nestedloop puzzle! @TeachCode @TeachMrReed @CarstarphenMJ @apsupdate @APSInstructTech

Wahnsinn! Kann man damit auch einen #NestedLoop im #Cybermode laufen lassen? 😍