投稿時間:2023-08-13 21:08:19 RSSフィード2023-08-13 21:00 分まとめ(11件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
AWS	lambdaタグが付けられた新着投稿 - Qiita	NestJSをAPI Gateway + AWS Lambdaで構成する（その８） AWSへのデプロイ	https://qiita.com/ssugimoto/items/74c26a8219a944d4acc4	apigatewayawslambda	2023-08-13 20:52:10
js	JavaScriptタグが付けられた新着投稿 - Qiita	resolve()を呼んだらthen()の中がすぐ実行されると勘違いしてました	https://qiita.com/yasurageruheya/items/c7f66da8959550dad172	promise	2023-08-13 20:57:10
技術ブログ	Developers.IO	人事評価関連まとめ記事	https://dev.classmethod.jp/articles/matome-evaluation/	developersi	2023-08-13 11:15:09
海外TECH	MakeUseOf	How to Add Random Moving Objects in Pygame	https://www.makeuseof.com/pygame-random-moving-objects/	pygame	2023-08-13 11:00:24
海外TECH	DEV Community	PostgreSQL Optimization: A Quick Tip on Using Values Expression	https://dev.to/nightbird07/postgresql-optimization-a-quick-tip-on-using-values-expression-2fce	PostgreSQL Optimization A Quick Tip on Using Values ExpressionI have been working with a database that contains thousands of clusters of women each identified by a UUID The challenge arises when implementing a clustering algorithm that involves determining if a new cluster exists within a larger cluster Traditionally achieving this might necessitate iterative loops in programming languages like Python adding complexity to the codebase Leveraging SQL PowerInstead of resorting to external looping mechanisms PostgreSQL provides a more streamlined approach using SQL itself The IN keyword widely used to filter results can be used to solve this clustering dilemma For instance SELECT FROM clustersWHERE cluster id IN over IDs However let s explore an even more efficient way to accomplish this using the values expression and the ANY operator This technique can yield performance improvements and optimize query execution plans The Values Expression and ANY OperatorThe values expression constructs a temporary table from a list of expressions while the ANY operator evaluates if a value is equal to any element within an array or set Integrating these constructs the query can be reimagined as SELECT FROM clustersWHERE cluster id ANY VALUES Surprisingly this seemingly straightforward alteration can lead to a different and more efficient query execution plan The database optimizer might choose to employ hash aggregation over values scanning and potentially hash joins when dealing with a substantial number of rows Impact on PerformanceAt first glance this query rewrite might appear counterintuitive However its effect on performance can be profound contingent on the underlying context If the query planner orchestrates the values scan after completing all joins it could lead to undesirable consequences On the flip side when the planner optimally schedules execution query performance can experience a remarkable boost In certain cases this optimization technique has resulted in up to times faster query execution a substantial gain that can outweigh the perceived risk It s crucial to note that the sequence of execution within the database is determined by the planner s internal tree structure Generally joins are prioritized over the WHERE clause prompting their execution before filtering with the WHERE condition If you re interested in modifying this behavior PostgreSQL offers hints to guide query optimization However the detailed exploration of hints falls beyond the scope of this article ConclusionIn the realm of database optimization the PostgreSQL database system never ceases to amaze with its wealth of features This quick tip of utilizing the values expression and ANY operator for enhancing clustering queries showcases how intricate optimizations can lead to remarkable performance gains While the impact of this technique might vary depending on the specific use case its potential to dramatically accelerate query execution makes it an invaluable tool in the database optimization toolkit	2023-08-13 11:50:18
Apple	AppleInsider - Frontpage News	Crime blotter: Apple Stores hit with forklift, serial thefts, and slight-of-hand cash robbery.	https://appleinsider.com/articles/23/08/13/crime-blotter-apple-stores-hit-with-forklift-serial-thefts-and-slight-of-hand-cash-robbery?utm_medium=rss	Crime blotter Apple Stores hit with forklift serial thefts and slight of hand cash robbery In the latest Apple Crime Blotter a viral plane incident began with an AirPods dispute a SIM swapper pleads guilty and the case of an AirPod theft from a school wraps up four years later The Apple Store in Downtown Los AngelesThe latest in an occasional AppleInsider series looking at the latest news in Apple related crime Read more	2023-08-13 11:36:02
ニュース	BBC News - Home	Maui fire: 93 killed as governor warns of 'significant' death toll rise	https://www.bbc.co.uk/news/world-us-canada-66489815?at_medium=RSS&at_campaign=KARANGA	hawaii	2023-08-13 11:11:44
ニュース	BBC News - Home	Ministers face renewed pressure over boat crossings	https://www.bbc.co.uk/news/uk-66490218?at_medium=RSS&at_campaign=KARANGA	boats	2023-08-13 11:41:42
ニュース	BBC News - Home	Campsite car crash: Nine hurt in Newgale, Pembrokeshire	https://www.bbc.co.uk/news/uk-wales-66490869?at_medium=RSS&at_campaign=KARANGA	newgale	2023-08-13 11:30:28
ニュース	BBC News - Home	Pub takeaway drinks rules to be continued	https://www.bbc.co.uk/news/business-66491373?at_medium=RSS&at_campaign=KARANGA	rules	2023-08-13 11:48:09
ニュース	BBC News - Home	The Hundred 2023: Ecclestone's stunning caught and bowled	https://www.bbc.co.uk/sport/av/cricket/66492182?at_medium=RSS&at_campaign=KARANGA	litchfield	2023-08-13 11:18:20