HackerTrans
トップ新着トレンドコメント過去質問紹介求人

radimm

1,790 カルマ登録 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

投稿

Vacuum at the Page Level

boringsql.com
27 ポイント·投稿者 radimm·6 日前·5 コメント

The Null in Your Not IN

boringsql.com
4 ポイント·投稿者 radimm·27 日前·1 コメント

New Hetzner price increase (As of 15 June)

hetzner.com
10 ポイント·投稿者 radimm·27 日前·2 コメント

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

cleantechnica.com
3 ポイント·投稿者 radimm·先月·0 コメント

Toast: Where PostgreSQL hides big values

boringsql.com
2 ポイント·投稿者 radimm·2 か月前·0 コメント

Welcome to ORDER BY Jungle

boringsql.com
2 ポイント·投稿者 radimm·2 か月前·0 コメント

Strong Views on PostgreSQL VIEWs

boringsql.com
1 ポイント·投稿者 radimm·2 か月前·0 コメント

A Gopher Meets a Crab

miren.dev
47 ポイント·投稿者 radimm·2 か月前·76 コメント

Hot Updates in Postgres

boringsql.com
1 ポイント·投稿者 radimm·2 か月前·2 コメント

PostgreSQL MVCC, Byte by Byte

boringsql.com
4 ポイント·投稿者 radimm·3 か月前·0 コメント

PostgreSQL MVCC, Byte by Byte

boringsql.com
3 ポイント·投稿者 radimm·3 か月前·0 コメント

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

github.com
2 ポイント·投稿者 radimm·3 か月前·1 コメント

Don't let AI touch your production database

boringsql.com
4 ポイント·投稿者 radimm·3 か月前·0 コメント

Good CTE, Bad CTE

boringsql.com
203 ポイント·投稿者 radimm·3 か月前·45 コメント

[untitled]

1 ポイント·投稿者 radimm·4 か月前·0 コメント

PostgreSQL Statistics: Why queries run slow

boringsql.com
3 ポイント·投稿者 radimm·4 か月前·0 コメント

The 8KB Page: PostgreSQL Page Layout Visualized

boringsql.com
2 ポイント·投稿者 radimm·5 か月前·0 コメント

PostgreSQL's 8KB Page

boringsql.com
3 ポイント·投稿者 radimm·5 か月前·0 コメント

Reading Buffer statistics in EXPLAIN output

boringsql.com
1 ポイント·投稿者 radimm·5 か月前·0 コメント

PostgreSQL Shared Buffers Visualized

boringsql.com
1 ポイント·投稿者 radimm·6 か月前·0 コメント

コメント

radimm
·3 日前·議論
OP here - correct, I guess I should clarify soon.
radimm
·6 日前·議論
Thank you! And you are right. Many people forgot about idle-in-transaction backends.
radimm
·27 日前·議論
Full comparison https://docs.hetzner.com/general/infrastructure-and-availabi...
radimm
·27 日前·議論
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 か月前·議論
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 か月前·議論
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 か月前·議論
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 か月前·議論
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 か月前·議論
[dead]
radimm
·3 か月前·議論
Thanks - I will recheck later today.
radimm
·3 か月前·議論
OP here, damn - that's a very good point. Can't believe I missed it.
radimm
·3 か月前·議論
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 か月前·議論
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 か月前·議論
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 か月前·議論
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 か月前·議論
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 か月前·議論
Yes, I'm Czech.
radimm
·7 か月前·議論
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 か月前·議論
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 か月前·議論
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 ;-)