Show newer

@nixCraft

... Undocumented.

The term is such an anti-pattern.

Join @PavloGolub (CYBERTEC) for his PGDay Lowlands session and learn how to customize the Wordle game experience with #Postgres. Get your ticket now: 2024.pgday.nl/registration/

@jawnsy

The stock image was running Kernel 6.1, which predates your LKML post, so would depend if it was backported.

I want to have a play with UEFI support and get mainline booting when I get a chance.

@jawnsy @yawnbox

Not sure if any acceleration was in use. 50% perf hit for encryption is a bit more than I expected TBH.

In general the IO throughput seemed better than I expected. Easily beats an RPI CM4 with an SSD.

Was testing pretty quickly, might play a bit more if I get some time in the week.

@jawnsy @yawnbox

IO Benchmarks:

IO, 1 job:
write: IOPS=239k, BW=933MiB/s
readwrite: read: IOPS=128k, BW=499MiB/s; write: IOPS=128k, BW=499MiB/s

IO, 4 jobs:
write: IOPS=686k, BW=2681MiB/s
readwrite: read: IOPS=453k, BW=1770MiB/s; write: IOPS=453k, BW=1770MiB/s

DM-Crypt IO, 1 job:
readwrite: read: IOPS=75.7k, BW=296MiB/s; write: IOPS=75.7k, BW=296MiB/s

DM-Crypt IO, 4 jobs:
readwrite: read: IOPS=235k, BW=918MiB/s; write: IOPS=235k, BW=917MiB/s

@jawnsy @yawnbox

I did some benchmarking of the Rock 5B, stock install of the provided OS. Power stats taken directly from lab bench PSU. Power looks to easily be under 20W for most applications.

Rock 5B (16GB) with Crucial P3 512GB SSD, running Linux rock-5b 6.1.43-14-rk2312.

Power:
Idle: 5V @ 0.66A
All CPU stress: 5V @ 1.39A
Single CPU Stress: 5V @ 0.81A
7Zip Bench: 5V @ 2.18A
CPU Stress + IO RW: 5V @ 1.69A
IO 1 Job RW: 5V @ 1.32A
IO 1 Job W: 5V @ 1.71A
Multi-job IO: 5V @ 1.71A - 2A

New episode of the #TalkingPostgres podcast with Claire Giordano (previously called #PathToCitusCon)

In Ep18, David Rowley & I talk about how David got his start as a developer & in #PostgreSQL. Starting from motorbikes 🏍️ & cheese factories 🧀 to working as a prolific Postgres committer on the Postgres query planner (and more!)

Let me know what you think! // Boosts much appreciated ❤️

🎧 talkingpostgres.com/episodes/h
📺 aka.ms/TalkingPostgres-Ep18-yo

#community #podcast #Postgres #OpenSource #Microsoft

@yawnbox I suspect for your usecases it would be <= 20W.

It's probably being cautious on what peripherals people attach.

AFAIK it's the same CPU as the Orange PI Max.

I can measure the power consumption of mine over the weekend, if you want?

@yawnbox have a look at Rock 5B, available from RS and other places.

@dnavinci @ChrisMayLA6

Yes, I would agree pay is also behind where is needs to be. Especially the gulf between UK and US pay for the industry.

@ChrisMayLA6

Plus lots of (big) companies have got very used to paying large consultancies for poor outcomes, mostly driven by perceived cost savings per head on paper.

Taking a serious look at the internal company transfer visas would not be stupid, people get treated badly for capitalists gains.

@ChrisMayLA6

As someone in that sector, I think there are a number of key problems, specifically around the educational side. Computer Science is the degree course most people do, yet what people really want is Computer Engineers.

It's very much like trying to have Physics graduates roll into an Electronic Engineering job. They might posses the underlying knowledge in theory, but they lack any of the practical skills.

@azonenberg stupid question, shouldn't pin 1 of U1 be connected to vin (your schematic don't indicate that)?

Remember what Macquarie did to Thames water in the UK by loading it with debt before offloading it to others?

They are about to get full control of National Gas by buying out the last 20% from National Grid.

What could possibly go wrong?

reuters.com/markets/deals/macq

#thames #nationalgas #nationalgrid #assetstipping

"We are pleased to announce postgres-contrib.org, a new website started in July 2024 by members of the #PostgreSQL #community, highlighting contributions to the project by the amazing people standing behind it. Many contributions to and for the PostgreSQL Project happen outside of writing code..."

postgresql.org/about/news/anno

#Postgres #OpenSource #Database

More on the madness & inhumanity of the DWP's 'management' of carer's allowance....

As I've said before: we should be cherishing & rewarding unpaid carers, not putting them into a position of financial jeopardy.

Here's a change Labour can make right away with few if any fiscal implications.

Just stop the DWP penalising carers, now!

#socialcare #politics

theguardian.com/society/articl

Show older
Mastodon

Time for a cuppa... Earl Grey please!