efxhoy

9 ms·

61.
by efxhoy 3y ago
I think cheaper QLC chips use a part of their storage space as SLC, which is fast to write. But once you’ve written the fast part that fits in the SLC cache write throughput quickly tanks as it has to push the data further in to the slower
62.
by efxhoy 3y ago
If moving off the cloud was easy we’d all be doing it. For our org the risk is (unfortunately imo) bigger than the savings. I would love to pay hetzner dedicated boxes rates for compute but the amount of work to migrate everything would be
63.
by efxhoy 3y ago
> Bandcamp has always felt like it should be someone's lifestyle business Me too. Layoffs are terrible for the people involved but I honestly don’t see why bandcamp would need more than a handful of employees. The more people you ha
64.
by efxhoy 3y ago
TS requires you to specify a time column in each hypertable or view (continuous aggregate) where you want it to work its magic. It then stores an internal watermark that it compares to the time column in the table to figure out from where t
65.
by efxhoy 3y ago
> Don't be snarky. https://news.ycombinator.com/newsguidelines.html Are you expecting a real answer of how I was hoping timescale's internal watermark system would help me roll up a total count or are you just
66.
by efxhoy 3y ago
Another alternative to timescale could be hydra. Haven’t tried it myself but the promise of columnar tables seems wildly useful.
67.
by efxhoy 3y ago
I ran into issues with TS too. Main issue I recall now was maintaining a grand total count of events that were already rolled up into daily counts was not fast since it always looked back at all the data. There was no way in the ts patterns
68.
by efxhoy 3y ago
Oh wow that was news to me, thanks!
69.
by efxhoy 3y ago
No need for that. I didn’t know Clickhouse was now disconnected from the Russian government.
70.
by efxhoy 3y ago
Yeah. I’d love to use clickhouse but yandex ties to the russian government makes me not want to.
71.
by efxhoy 3y ago
Article hijacked my back button and gave no examples of what the projects were doing or why they were junk.
72.
by efxhoy 3y ago
> - Installing the extension itself does not change the default table type, this is only the case on Hydra Cloud and our Docker image. Ah cool, thanks! How would I go about adding the extension to my own "FROM postgres:15" Dock
73.
by efxhoy 3y ago
Big congrats on 1.0! Super exciting project. My dream scenario would be installing hydra as an extension into my main rails application database. My usecase is showing analytics numbers directly to users, like "how many people visited
74.
by efxhoy 3y ago
It makes setting up your own peer to peer VPN between your devices. https://tailscale.com/kb/1151/what-is-tailscale/
75.
by efxhoy 3y ago
Why add caching and sharding? Is the current architecture not going to keep up with demand?
76.
by efxhoy 3y ago
Very unhappy legal department. Very unhappy owners. Big fines. Publicly traded companies have a lot of rules to follow.
77.
by efxhoy 3y ago
The nice thing about index bloat is REINDEX has a CONCURRENTLY option, no need to block writes.
78.
by efxhoy 3y ago
Ive stuck with sublime text because it feels good when I use it, everything is fast and there is no clutter. For lack of a better comparison it feels like when you had just reinstalled windows XP back in the day. Fresh and snappy and clean.
79.
by efxhoy 3y ago
Ah yes that makes sense. It’s easy to forget how slow HDDs used to be and their mechanical nature of spinning disk and a head.
80.
by efxhoy 3y ago
After an ios update where my phone started tracking a move ring (I was lazy and accepted some new defaults) I was definitely more motivated to close it every day. I noticed I was walking more so a few weeks ago when my old watch died I boug
81.
by efxhoy 3y ago
> If you’re using a 10 Mbit hub and copy the same directory to two Windows SMB hosts simultaneously it is somehow smart enough to make the transfers coincide so it can transmit the same data to both at once. To this day I have no idea wh
82.
by efxhoy 3y ago
The only customization app I use is Rectangle. Try to embrace the oddities of the system instead of trying to make it behave exactly like you’re used to. Make it yours but don’t bother trying to make it i3 or windows or whatever. brew is pr
83.
by efxhoy 3y ago
The film really reminded me of what silicon valley, the series, would be like if it was set in that time frame. I thought it was funny.
84.
by efxhoy 3y ago
What’s GoF?
85.
by efxhoy 3y ago
I spent last week freeing up 200GB from our 600GB db with just reindex and pg_repack. The worst offender was a 17GB (of data) table that had 142GB of indexes. Reindex took it down to 21GB. The table indexing is crazy and has multiple indexe
86.
by efxhoy 3y ago
There are two types of devs at my job, those that care about shipping lots of new things fast, using new frameworks and pushing metrics. Then we have me and a few others fighting fires that the fast shippers leave behind. I’m fine with it,
87.
by efxhoy 3y ago
I needed to pass big dataframes between workers and the main thread. Turned out that the easiest way for me was having them write parquet files and reading them in the main thread.
88.
by efxhoy 3y ago
I just listened to George speak to Lex. He talked about the engineering time they spend in tinygrad to make it simpler. A lot of hours goes in to refactoring to make it as simple as it is. Writing simple software for complex problems takes
89.
by efxhoy 3y ago
My dad knows very little about computers but he likes joking with me whenever i’m struggling with some technical problem: “8 bits is a byte! That’s all you need to know! How hard could it be?”
90.
by efxhoy 3y ago
Did you maintain a separate branch for 8 months?

More ›