HackerTrans
TopNewTrendsCommentsPastAskShowJobs

radimm

1,790 karmajoined 15 anni fa
Writing some SQL for fun and profit, while enjoying PostgreSQL, Go and all things simple. Starting SQL Labs for boringSQL.

radim [at] boringsql [dot] com

Submissions

Vacuum at the Page Level

boringsql.com
27 points·by radimm·6 giorni fa·5 comments

The Null in Your Not IN

boringsql.com
4 points·by radimm·27 giorni fa·1 comments

New Hetzner price increase (As of 15 June)

hetzner.com
10 points·by radimm·27 giorni fa·2 comments

Gotion Unveils Sodium Battery Products with 261 Wh/Kg Energy Density

cleantechnica.com
3 points·by radimm·mese scorso·0 comments

Toast: Where PostgreSQL hides big values

boringsql.com
2 points·by radimm·2 mesi fa·0 comments

Welcome to ORDER BY Jungle

boringsql.com
2 points·by radimm·2 mesi fa·0 comments

Strong Views on PostgreSQL VIEWs

boringsql.com
1 points·by radimm·2 mesi fa·0 comments

A Gopher Meets a Crab

miren.dev
47 points·by radimm·2 mesi fa·76 comments

Hot Updates in Postgres

boringsql.com
1 points·by radimm·2 mesi fa·2 comments

PostgreSQL MVCC, Byte by Byte

boringsql.com
4 points·by radimm·3 mesi fa·0 comments

PostgreSQL MVCC, Byte by Byte

boringsql.com
3 points·by radimm·3 mesi fa·0 comments

Show HN: DryRun – PostgreSQL MCP and schema advisor that works offline

github.com
2 points·by radimm·3 mesi fa·1 comments

Don't let AI touch your production database

boringsql.com
4 points·by radimm·3 mesi fa·0 comments

Good CTE, Bad CTE

boringsql.com
203 points·by radimm·3 mesi fa·45 comments

[untitled]

1 points·by radimm·4 mesi fa·0 comments

PostgreSQL Statistics: Why queries run slow

boringsql.com
3 points·by radimm·4 mesi fa·0 comments

The 8KB Page: PostgreSQL Page Layout Visualized

boringsql.com
2 points·by radimm·5 mesi fa·0 comments

PostgreSQL's 8KB Page

boringsql.com
3 points·by radimm·5 mesi fa·0 comments

Reading Buffer statistics in EXPLAIN output

boringsql.com
1 points·by radimm·5 mesi fa·0 comments

PostgreSQL Shared Buffers Visualized

boringsql.com
1 points·by radimm·6 mesi fa·0 comments

comments

radimm
·l’altro ieri·discuss
OP here - correct, I guess I should clarify soon.
radimm
·5 giorni fa·discuss
Thank you! And you are right. Many people forgot about idle-in-transaction backends.
radimm
·27 giorni fa·discuss
Full comparison https://docs.hetzner.com/general/infrastructure-and-availabi...
radimm
·27 giorni fa·discuss
For example CPX 42 went from € 0.0408/h (25.49 per month) to € 0.1114/h (69.49 per month).

Was expecting price hike but not this level.
radimm
·2 mesi fa·discuss
Markus never fails to deliver. I actually haven’t realised how SQL standard handles ORDER BY on non-selected columns by just rewriting the SELECT clause behind your back.

Separation of concerns ruthlessly broken ;-)))
radimm
·2 mesi fa·discuss
Somehow it feel HOT updates are very confusing. You can also try to play with interactive visualizer to understand it better https://boringsql.com/visualizers/hot-updates/
radimm
·3 mesi fa·discuss
This is the message the author posted on LinkedIn:

After a lot of thought, I have decided to stop working on pgBackRest. I did not come to this decision lightly. pgBackRest has been my passion project for the last thirteen years, and I was fortunate to have corporate sponsorship for much of this time, but there were also many late nights and weekends as I worked to make pgBackRest the project it is today, aided by numerous contributors. Every open-source developer knows exactly what I mean and how much of your life gets devoted to a special project.

Since Crunchy Data was sold, I have been maintaining pgBackRest and looking for a position that would allow me to continue the work, but so far I have not been successful. Likewise, my efforts to secure sponsorship have also fallen far short of what I need to make the project viable.

Like everyone else, I need to make a living, and the range of pgBackRest-related roles is very limited. I can now consider a wider variety of opportunities, but those will not leave me time to work on pgBackRest, which requires a fair amount of time for maintenance, bug fixes, PR reviews, answering issues, etc. That does not even include time to write new features, which is what I really love to do. Rather than do the work poorly and/or sporadically, I think it makes more sense to have a hard stop.

I will post a notice of obsolescence and archive the repository. I imagine at some point pgBackRest will be forked, but that will be a new project with new maintainers, and they will need to build trust the same way we did.

Again, many thanks to all the pgBackRest contributors over the years. It was a pleasure working with you!
radimm
·3 mesi fa·discuss
One of the benefit is that instead of LLM blindly advising you to do

> ALTER TABLE customers ALTER COLUMN email SET NOT NULL;

it can advise you to

-- Step 1: backfill NULLs UPDATE customers SET email = 'unknown-' || id || '@example.com' WHERE email IS NULL;

-- Step 2: add constraint without full table scan ALTER TABLE customers ADD CONSTRAINT customers_email_not_null CHECK (email IS NOT NULL) NOT VALID;

-- Step 3: validate in the background with a weaker lock ALTER TABLE customers VALIDATE CONSTRAINT customers_email_not_null;
radimm
·3 mesi fa·discuss
[dead]
radimm
·3 mesi fa·discuss
Thanks - I will recheck later today.
radimm
·3 mesi fa·discuss
OP here, damn - that's a very good point. Can't believe I missed it.
radimm
·3 mesi fa·discuss
This is exactly same struggle for me. Writing technical content about PostgreSQL and balancing my voice without sounding like LLM written is genuinely difficult.

As English is not my first language, I do run into problem where the line between fix my clumsy sentence and rewrite my thought is very thin. Same with writing "boring" technical explanation and more approachable content. I'm getting pushed back for both.
radimm
·6 mesi fa·discuss
Not OP - but definitely no. In such a case use just physical or - if you have special use case - logical replication that’s built in.
radimm
·7 mesi fa·discuss
OP here - still have to try (generally operate on VM/bare metal level); but my understanding is that ioctl call would get passed to the underlying volume; i.e. you would have to mount volume
radimm
·7 mesi fa·discuss
OP here - yes, this is my use case too: integration and regression testing, as well as providing learning environments. It makes working with larger datasets a breeze.
radimm
·7 mesi fa·discuss
Actually, a "ghost station" shell has existed under Satellite 3 since 1998, though it was never finished or opened to passengers. The tunnel was built that far just to give the trains space to turn around.
radimm
·7 mesi fa·discuss
Yes, I'm Czech.
radimm
·7 mesi fa·discuss
I wouldn't usually use the 'non-native speaker argument', but thank you! Just yesterday I was accused of sounding like AI - https://news.ycombinator.com/item?id=46262777 - my default mode is that I oscillate between sounding too boring/technical, or when trying to do my best, sounding like AI
radimm
·7 mesi fa·discuss
OP here - thank you for mentioning replica, forgot to mention it. Unless it would hit it pretty hard and `hot_standby_feedback` is on
radimm
·7 mesi fa·discuss
Author here – it’s actually funny, as you pointed out parts that are my own (TM) attempts to make it a bit lighthearted.

LLM is indeed used for correction and improving some sentences, but the rest is my honest attempt at making writing approachable. If you’re willing to invest the time, you can see my fight with technical writing over time if you go through my blog.

(Writing this in the middle of a car wash on my iPhone keyboard ;-)