HackerTrans
TopNewTrendsCommentsPastAskShowJobs

radimm

1,790 karmajoined 15 лет назад
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 дней назад·5 comments

The Null in Your Not IN

boringsql.com
4 points·by radimm·27 дней назад·1 comments

New Hetzner price increase (As of 15 June)

hetzner.com
10 points·by radimm·27 дней назад·2 comments

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

cleantechnica.com
3 points·by radimm·в прошлом месяце·0 comments

Toast: Where PostgreSQL hides big values

boringsql.com
2 points·by radimm·2 месяца назад·0 comments

Welcome to ORDER BY Jungle

boringsql.com
2 points·by radimm·2 месяца назад·0 comments

Strong Views on PostgreSQL VIEWs

boringsql.com
1 points·by radimm·2 месяца назад·0 comments

A Gopher Meets a Crab

miren.dev
47 points·by radimm·2 месяца назад·76 comments

Hot Updates in Postgres

boringsql.com
1 points·by radimm·2 месяца назад·2 comments

PostgreSQL MVCC, Byte by Byte

boringsql.com
4 points·by radimm·3 месяца назад·0 comments

PostgreSQL MVCC, Byte by Byte

boringsql.com
3 points·by radimm·3 месяца назад·0 comments

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

github.com
2 points·by radimm·3 месяца назад·1 comments

Don't let AI touch your production database

boringsql.com
4 points·by radimm·3 месяца назад·0 comments

Good CTE, Bad CTE

boringsql.com
203 points·by radimm·3 месяца назад·45 comments

[untitled]

1 points·by radimm·4 месяца назад·0 comments

PostgreSQL Statistics: Why queries run slow

boringsql.com
3 points·by radimm·4 месяца назад·0 comments

The 8KB Page: PostgreSQL Page Layout Visualized

boringsql.com
2 points·by radimm·5 месяцев назад·0 comments

PostgreSQL's 8KB Page

boringsql.com
3 points·by radimm·5 месяцев назад·0 comments

Reading Buffer statistics in EXPLAIN output

boringsql.com
1 points·by radimm·5 месяцев назад·0 comments

PostgreSQL Shared Buffers Visualized

boringsql.com
1 points·by radimm·6 месяцев назад·0 comments

comments

radimm
·позавчера·discuss
OP here - correct, I guess I should clarify soon.
radimm
·5 дней назад·discuss
Thank you! And you are right. Many people forgot about idle-in-transaction backends.
radimm
·27 дней назад·discuss
Full comparison https://docs.hetzner.com/general/infrastructure-and-availabi...
radimm
·27 дней назад·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 месяца назад·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 месяца назад·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 месяца назад·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 месяца назад·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 месяца назад·discuss
[dead]
radimm
·3 месяца назад·discuss
Thanks - I will recheck later today.
radimm
·3 месяца назад·discuss
OP here, damn - that's a very good point. Can't believe I missed it.
radimm
·3 месяца назад·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 месяцев назад·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 месяцев назад·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 месяцев назад·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 месяцев назад·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 месяцев назад·discuss
Yes, I'm Czech.
radimm
·7 месяцев назад·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 месяцев назад·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 месяцев назад·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 ;-)