Urgent.News

What's breaking now, across thousands of outlets.

Tech

New series for beginners - check it out! ☕

What is a program? Your first 10 minutes of code (Cuppa and Code #1) Amy Hudspith Amy Hudspith Amy Hudspith Follow Nov 1 What is a program? Your first 10 minutes of code (Cuppa and Code #1) # python # beginners # tutorial # jupyter

We haven't written up this one. Dev.to has the full story — the link below goes straight to it.

Read the original at dev.to →

More in Tech

Changing one number from 32 to 34 made a Postgres query 6,000 faster. Here's exactly why.

Who this is for: anyone who has seen a Postgres query that should be fast but isn't, and EXPLAIN shows a bad plan without saying why. You don't need to know planner internals.

  • Raising joincollapselimit from 32 to 34 made query 6,000 times faster
  • Nested loop step joined 435 tables, then filtered out non-matching rows
  • Selecting fewer columns reduced unnecessary tables returned by planner

More from Sunday 1 November →