radimm

7 ms·

31.
by radimm 6mo ago
Thanks - I will recheck later today.
32.
by radimm 6mo ago
OP here, damn - that's a very good point. Can't believe I missed it.
33.
by radimm 6mo ago
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 betw
34.
Good CTE, Bad CTE(boringsql.com)
203 points by radimm 6mo ago|45 comments
35.
PostgreSQL Statistics: Why queries run slow(boringsql.com)
3 points by radimm 7mo ago|0 comments
36.
The 8KB Page: PostgreSQL Page Layout Visualized(boringsql.com)
2 points by radimm 8mo ago|0 comments
37.
PostgreSQL's 8KB Page(boringsql.com)
3 points by radimm 8mo ago|0 comments
38.
Reading Buffer statistics in EXPLAIN output(boringsql.com)
1 points by radimm 8mo ago|0 comments
39.
PostgreSQL Shared Buffers Visualized(boringsql.com)
1 points by radimm 9mo ago|0 comments
40.
Introduction to Buffers in PostgreSQL(boringsql.com)
2 points by radimm 9mo ago|0 comments
41.
by radimm 9mo ago
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.
42.
The Cost of PostgreSQL Arrays(boringsql.com)
2 points by radimm 9mo ago|0 comments
43.
by radimm 10mo ago
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
44.
by radimm 10mo ago
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.
45.
by radimm 10mo ago
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.
46.
Instant database clones with PostgreSQL 18(boringsql.com)
435 points by radimm 10mo ago|162 comments
47.
by radimm 10mo ago
Yes, I'm Czech.
48.
by radimm 10mo ago
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
49.
by radimm 10mo ago
OP here - thank you for mentioning replica, forgot to mention it. Unless it would hit it pretty hard and `hot_standby_feedback` is on
50.
by radimm 10mo ago
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 app
51.
by radimm 10mo ago
Author here - thank you for the comments. This article is indeed playing a lot on verge of clickbait and I did asked about that shortly after publishing.
52.
Vacuum Is a Lie (About Your Indexes)(boringsql.com)
5 points by radimm 10mo ago|0 comments
53.
by radimm 11mo ago
Hey, thank you for follow-up. Really appreciated. This is why I decided to go out and show RegreSQL. You're absolutely right that in an ideal world, every project would have solid integration tests covering their database access querie
54.
by radimm 11mo ago
Let me be clear - this is just baseline testing that's only valid for similar data patterns, same cardinality, and so on. Plus it's currently using EXPLAIN, so we're working with estimates, not actual execution data. But from
55.
by radimm 11mo ago
For now the syntax is not fully compatible - but my goal is to add https://github.com/boringSQL/queries (library behind SQL files parsing) to better align on it. It's definitely on my radar
56.
by radimm 11mo ago
I'm obviously biased. Adding MySQL support is not that difficult but maintenance is (and ultimately PostgreSQL is better way forward (half joking :)) With current feature set it's something I have already considered but still unde
57.
by radimm 11mo ago
OP here - I'm going to follow up with the separate article on pgTap. But the goals of both tools is slightly different in my mind.
58.
by radimm 11mo ago
For now only fixtures support transaction as cleanup options, but that's a good point that tested queries might also modify the queries. I will definitely reach out, just give me bit of time to mentally recover from the exposure and go
59.
by radimm 11mo ago
It's not unreasonable view - noted, will add to my list. Thank you!
60.
by radimm 11mo ago
At this point it supports initialization through the fixtures systems (like inline SQL or SQL files). At the moment they have fixed order, which might lead to some limitations, but I'm already thinking about some pre/post test set

More ›