Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
daneel_w
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
7 ms
·
91.
▲
by
daneel_w
5mo ago
> Why should I switch over to something way less proven? Must they prove their software to you? They're offering an alternative, not bargaining for a deal.
92.
▲
by
daneel_w
5mo ago
The aspect ratio is correct on all screenshots and are accurate de-interlaced representations of a 640x400/512 workbench setup, even though these particular screenshots are in RTG dimensions. Starting with ECS, the Amiga was also capab
93.
▲
by
daneel_w
5mo ago
I'm sure someone reading this thread has UAE handy in order to contribute a screenshot of AmigaOS/Workbench 1.x.
94.
▲
by
daneel_w
5mo ago
I have the A1 Mini as well. Mostly having sat unused since I bought it a few years back, I'm now wondering if the thing will function normally again. Any advice on basic "cold boot" maintenance? It's been a year since I
95.
▲
by
daneel_w
5mo ago
If you with "he" mean Daniel Micay, I unfortunately agree, based on observations from previously having idled in the GOS Discord for a couple of years. Plenty of downright mean and unforgiving behavior, not seldom due to him misin
96.
▲
by
daneel_w
5mo ago
If you are referring to his video from May 2023, "Why I deleted GrapheneOS", it is about the team lead, Daniel Micay, not about GrapheneOS itself. He, in fact, praises GrapheneOS to no end in the very same video.
97.
▲
by
daneel_w
5mo ago
My approach is to run a VPS with multiple static IPs that I (using Wireguard) tunnel to a number of virtual machines I host at home on a microserver. Likewise, the virtual machines' primary view of the Internet starts on the opposite s
98.
▲
by
daneel_w
5mo ago
Yeah, theoretically. They "only" need continued access to CF's internal systems. Surely you're aware that the ZSK is confined to your zone and can be rotated as much as you want without having to involve the root/re
99.
▲
by
daneel_w
5mo ago
Which is fine. Not because KSK rollover is supposedly complicated, but if you can't manage to keep your private keys and PKI safe in the first place then key rotation is just a security circus trick. But if you do know how to keep them
100.
▲
by
daneel_w
5mo ago
And then fax the form to the correct authority, so that the request is Official(tm).
101.
▲
by
daneel_w
5mo ago
Besides fangs and claws, a substantial amount of both predators and non-predators have highly evolved camouflage.
102.
▲
by
daneel_w
5mo ago
So is it 5 or 10 years? Another person responding in this same branch says it used to be 10 but is now 5.
103.
▲
by
daneel_w
5mo ago
Using BRIN for certain columns resulted in an improvement. Thanks for the suggestion.
104.
▲
by
daneel_w
5mo ago
Thanks a bunch for all of the config tuning advice. Can see huge improvements in both flattening the creeping slow-down and really pushing back the point where we eventually hit the wall. Just lowering the fill factor on the indices made a
105.
▲
by
daneel_w
5mo ago
Why wouldn't they be doing it? They are actively engaged in such campaigns in various other media for foreign audiences. Wikipedia being blocked for the Chinese general population doesn't mean The Party isn't targeting it to
106.
▲
by
daneel_w
5mo ago
My impression is that InnoDB (MySQL's primary storage engine) is doing something like this. We have never seen any slow-downs on adding to the data set I've discussed in this thread, even at hundreds of millions of rows, and per t
107.
▲
by
daneel_w
5mo ago
Thanks for sharing this "tactic". Will look into it.
108.
▲
by
daneel_w
5mo ago
We've reached the same conclusion in other situations. Great for reliable and scalable storage, not so great for focused intense i/o.
109.
▲
by
daneel_w
5mo ago
> Why are you using hash indexes? On some data, for certain ways of using and querying that data, it makes a lot more sense than a b-tree. When we use hash indices for some of the columns in our test just to see how Postgres will perfo
110.
▲
by
daneel_w
5mo ago
In this case that is not the problem.
111.
▲
by
daneel_w
5mo ago
> This assertion is likely wrong We can clearly see with iostat/iotop that the server and its storage isn't overworked. > Is this PostgreSQL managed or self-hosted? We're evaluating on our own bare metal. It's
112.
▲
by
daneel_w
5mo ago
Ext4 with journaling. I've played around with XFS as well just to see what would happen. No major difference. I'm certain it's caused by the way Postgres builds its indices.
113.
▲
by
daneel_w
5mo ago
> So you open transaction, insert multiple rows, commit? Pretty much, yes. High volume rapid multi-row INSERTs. Nothing special involved in the DDL or how the data goes into the table. Vacuuming the table (whether automatically or betw
114.
▲
by
daneel_w
5mo ago
They are fully stable and perform very well in Postgres today. There are some caveats, but they don't result in any sort of hiccups or unpredictable behavior.
115.
▲
by
daneel_w
5mo ago
> problem is table design and write amplification. Every row insert triggers update into every index, so you get classic amplification problem. Yes, this is understood. In particular for b-trees that require some refurnishing when grow
116.
▲
by
daneel_w
5mo ago
"Overall, we find a Postgres server can handle up to 144K of these writes per second. That’s a lot, equivalent to 12 billion writes per day." Based on a problem I'm facing with Postgres today, I wonder if this really progre
117.
▲
by
daneel_w
6mo ago
I've built a lot of API backends with Perl and FCGI::ProcManager, letting nginx (and Apache HTTPd in the past) front everything. For me it has been a pleasantly simple, incredibly robust and high-performing setup with no mess to speak
118.
▲
by
daneel_w
6mo ago
With the exception of summed size of selected items, the Finder has all of that. Help yourself to the "View->Show Status Bar" menu option. Also, "View->Show View Options->Calculate All Sizes" to show storage siz
119.
▲
by
daneel_w
6mo ago
Netatalk has been around for like 25 years: https://github.com/Netatalk/Netatalk Relevant to the discussion is that the project comes with an AFP client as well. I have no experience with the client but I've used
120.
▲
by
daneel_w
6mo ago
Something quite acidic after the meal works great for me. I prefer a small glass of water with two tablespoons of apple cider vinegar. It's not tasty but it's just one quick swig, and as a bonus fermented beverages/foods are
More ›