If you missed my previous post on Understanding Postgres Performance its a great starting point. On this particular post I’m going to dig in to some real life examples of optimizing queries and indexes.


It all starts with stats



I wrote about…

A deliberate power outage by the state’s largest utility sent residents scrambling — and debating whether it was worth it.

📈 A small, fast chart for time series, lines, areas, ohlc & bars - leeoniya/uPlot

Apple and Blizzard have been pulled into a political struggle, and the platforms are part of the playing field

Despite being ringed on all sides by the UK – Northern Ireland to west, Scotland to the north, England to the east and Wales to the south – the Isle of Man is not actually part of it.

Apple is not your friend. Google is not your friend. Facebook is not your friend. Microsoft is not your friend… No venture-capital-funded startup, no billion or trillion dollar corporation is your friend. https://t.co/KjZy9KrLtE

A protip by dotcode about shell, cli, unix, and bash.

Engie has been selected to supply a solar power plant in Guam with 50 MWdc of generation capacity and approximately 300 MWh of storage - with the express purpose to deliver 100% of the electricity after sunset.

NEWS HIGHLIGHTS

Take that, reviewer number 2.

Carriers for La Poste have a new job: checking in on the aged.

Rwanda is becoming an innovation and tech hub.

Long-term changes to the brain’s structure and chemistry are an indicator “of how sinister bullying is” says Tracy Vaillancourt, a developmental psychologist at the University of Ottawa.

Linus Torvalds was asked if he thinks there's anything to fear from Microsoft's recent embrace of all things Linux and open source — this is what he said.

The new study demonstrates a bizarre quantum effect at never-before-seen scales

Network data from the NetBlocks internet observatory confirm that Iraq has introduced a nighttime internet curfew, consistent with reports from IT industry workers in recent days. Confirmed: #Iraq has partly ...