skysight-inc/HackerNews huggingface dataset:
While pinning a single plan or disabling parallel operations is a valid quick fix, I'd recommend trying to actually understand why the optimizer is doing what it's doing. It's all "just" a simple math of execution node costs. The problem with plan hints, or disabling parallel, is that unless you have a perfect understanding of where the data will be in, say, a year, you may just have created another problem, just delayed. Some column will go from 10 to 10,000 unique values and your good plan will become way off. And at the end, perhaps you just need to tell PG that an index access is not 4 times as expensive as a plain heap scan.

ps fighting the optimizer is the worst
That is a quite apt way to put it.
> The poster you’ve replied to mention that they are 53. They for sure learned to drive and move around the world for a couple decades before consumer GPS navigation solutions were affordable for hobbyists.

Garmin portable units like the Street Pilot were available in 1998 for 400usd when the 53 year old would have been 27 years old.
What you describe is simple, especially in a wealthy nation during peace. What doesn't sound so simple was leading union politics or rapidly rising through the ranks while deployed abroad. This person was certainly not quiet.
FWIW I recently reverted to Arch after five years because Void broke itself completely, but it was otherwise a decent OS.
It wasn't that much back then, especially when the industry was feast or famine (and it did implode in 1986 or so). But really, my only point was "a guy who had an associates degree from a CC could earn that much."

My buying power is essentially worse than my dad's, although I put in a lot more time in school for it, and supposedly made the right career choice, things just suck these days and techies are keeping their heads above water but not much more.
Thanks you, I will have a look
“ after a day driving a laundry truck. His bride, Grace, snapped the photo outside their first house.”

Driving a laundry truck.. first house..

Life was so much better a few decades ago.
Interesting! We did something similar for distributed query engines like presto and Spark, instead of indexes we use partitions and buckets, the benefits are less compute, time and money.
The really interesting thing about their proposed measure is that it reduces the period of extremely low interest rates post GFC. We'd be living in a very different world had this been our north star throughout that decade.
If you can afford fresh food, having enough preserved foods to require an organizer is a sign that you have room to improve your diet.
How Meta Nuked a Climate Story
I'm sorry but you just cannot say that "OR is bad" - it being a key part of SQL . It's most likely your use that is bad (e.g. your intermediate result exceeding some cache size).

But "bad performance always due to indexes" gives a hint that you are somewhat new: No, bad performance in my experience was almost always due to developers either not understanding their ORM framework, or writing too expensive queries with or without index. Just adding indexes seldom solved the problem (maybe 1/5 of the time).
https://archive.is/KKu4D
Can this unseal?

No. https://en.wikipedia.org/wiki/Double_seam
Kitchen store AND its website are closed on Sundays
I've never seen anything like this before. They've got 8 showrooms in the Netherlands, so it's not even a small company. This is the translated message on their website:

"Dear visitor,
Thank you for your interest in our organization. From our belief we keep Sunday as a day of rest in honor of our Creator. For this reason, all our business activities are shut down on Sundays. We hope for your understanding and are happy to welcome you on our site or in our showrooms on the other days of the week."
Wow! Really moved me.
I live in a metro city, and whenever I go back to my village, I envy their lives. It's just them and their families. Small World, but it still has adventures, and most importantly, peace.

A heart-warming Obituary!
A History of Medical Quackery: From Arsenic Soaps to Asthma Cigarettes and More
The sooner this type of job is automated the better imo. What’s the point of having people working so hard they end up dying?

Also I’ve suffered a misdiagnosis that ruined my life in my early years so it’s not like doctors are heroes either. We never hear about the failures only the successful stuff at the bleeding(heh) edge.

They make mistakes, they’re just humans.

Everyone glorifies their profession but what about the people who suffer misdiagnosis? Have to live the rest of their life in misery because of incompetence.
The end of Microsoft in Europe will be its poor security.

These massive integrated bundles of fluffy convenience are
cybersecurity death-traps that leak personal data like a rusty
bucket. Firms are rightly getting very nervous about massive fines,
and blaming MS is not a get-out. With Microsoft unable to reign-in the
complexity of their own products they'll lose market share to smaller,
more specialised but more secure systems.

Ironically the path to better security for Microsoft would be to
partition/split their own products as the anti-monopolists would have
them do.
Nice read, thank you.

> Ray Harrell after a day driving a laundry truck. His bride, Grace, snapped the photo outside their first house.

Ah the days when you could be a delivery truck driver and buy a house… Not so much for us anymore.
https://archive.ph/LS2C2
The Vacuity of Climate Science
> All around us are these lives — heads down and arms open — that ignore the siren call of flashy American individualism, of bright lights and center stage. I’m fine right here is the response from the edge of the room, and that contentment is downright subversive. How could you want only that? the world demands. There’s more to have, always more.

Beautiful writing, and I feel this part especially elevates it.

Going forward, we collectively need to recognize and celebrate these people who know when they have enough for a good life. Who can stop craving more fame, wealth and possession, and just appreciate what they have. Because only by doing so, can we leave enough resources for others, near or far, now and in the future, to have the same.
I had already contributed to some open source projects and had also done some fairly large freelance projects. I'm sure this made me more hireable.

I'm not sure I will give up anesthesiology 100%, in the end I'd like to combine and work on "medtech". Currently I work with automotive radar.

Feel free to reach out!
I teach my son that he doesn't have the right away, no matter what the laws really say, because even if the car is at fault, he is still dead (and that scares me). Cross walks only for now, and definitely no going to try and cross 15th NW (a four lane that carries lots of traffic) like that.

It does apply to invisible pedestrians, but cops are more likely to rule it a drive-at-fault accident than something more serious like negligent homicide. I live in Ballard, people park on either side here also, and...there isn't much buffer even at designated cross walks to see people waiting (or just going) to cross.
I saw an interview where Bill quipped "You know how we balanced the budget? We used a little thing called 'arithmetic'."
But then, he also had to serve in war. Medical care was not that advanced, you couldn't read about any niche topic you want online. Easy to see things through rose tinted glasses.
> People hate Teams/Office because it's so low quality

People hate Office? I don't think I've seen any significant hate for Microsoft Office (but I personally hate LibreOffice).

> calendar has hardcoded top-down management assumptions

What? Where? Is this about the list of other calendars defaulting to showing people under the same manager?

> information is siloed to only meeting participants

You can configure it to show meeting titles to everyone (the company I work for expects everyone to do so), and the new Outlook even showed me the meeting description and participants when peeking at someone else's calendar.
> What is never discussed, and isn't considered in this article, are certain types of other medical interventions - vaccination

It's very frequently discussed.

The downvotes you're expecting are because this meme can be traced to a fraudulent claim in 1998: https://en.wikipedia.org/wiki/Lancet_MMR_autism_fraud

I declined the MMR vaccine at school because I was at school when that story came out, and at that point he and his claim were taken somewhat seriously.

(I did get the vaccine eventually).

> For the very young, the brain does not 're-route' and developmental milestones are simply missed, whereas in adults it's possible to relearn skills

That's the exact opposite of how it works. E.g. language acquisition in adulthood is much harder.
I lament the vast reduction of street signs, at least in my country, that can be used for navigation. Like a sign that says to turn left for City X 15mi away. These used to be ubiquitous- you could get between city A and B through those signs alone. Sat Nav means there is vastly less need for signposting routes between major towns or landmarks. Growing up before sat nav, even as a child passenger, these signs helped me build a mental model of what was where and possibly train an early sense of direction.

When my kid was young I’d frequently ask them to draw to scale on paper the mental maps they have of where everything in their world is. I reckon this helped form their sense of direction. If you have a youngster and not tried this then give it a go, it’s illuminating. “Point to where you think X is” also helps train a kids sense of direction through feedback loops.
How should we apply? any email to contact
It's not about copyright in that nobody in the case mentioned the copyright doctrine.
This has been studied a lot in child welfare and is not currently believed, afaik. The diagnosis of reactive attachment disorder is acknowledged to have many overlapping symptoms with autism, but expressly differentiated as a condition.
> Oof. You'd have to be living under a rock to not know that Google is banned in China, but I guess some tourists just aren't tech savvy, so who am I to judge.

We hosted an ACM conference in 2011 in Beijing. One of my friends came, first trip to China, really smart guy just finishing up his PhD in EECS at UCB, but OMG did he mess that one up. We had to use the guest wifi in my office so he could make offline copies. If you aren't used to it, and don't follow China closely, you could be very technical and still be caught off guard. Lots of people will tell you China is just a normal tourist spot like Japan, Thailand, or Indonesia, but it really isn't.

> Also, a lot of these innovations seem to be a result of the Urumqi and Lhasa riots from 10-15 years ago as well as Tahrir Square, so clearly maintaining the political status quo seems to be top of mind.

I was in Beijing for those. A lot of things blocked afterwards, we slowly lost more services that we had previously. I would say 2008 was a peak for Chinese internet liberalization (and well, lots of other liberalization, I also spent 6 months in 2002 so can compare), and then it just tanked from that point on to present. They made a show for the Olympics and then decided they didn't need to bother anymore. It doesn't help that Xi is much more assertive and autocratic than Hu was.
> Why is the same library used for both internal service management and for services implementing on-demand launches and notifications?

Poettering was a Microsoft fan. I guess he designed SystemD like svchost.
I was quite skeptical of this. I've seen another company claiming to do the 3d generation do the same with their demos, they outsourced the "3d generation" part to low-wage workers in 3rd world countries and claimed the models to be generated by AI. I see this as a future trend to get investor money and do the rug pull.
Can there be technical things why cerain services get lower level service?

I’ve read that ISP buys various links to to other networks at various prices.

So maybe something like: if facebookBar server is on pricier linkFoo and for that reason ISP buys cheaper version of linkFoo effectively downgrading facebookBar service (along with everything on linkFoo)?

If such scenario is realistic, maybe it could be due to valid financial stuff, not due to anticompetetive behaviour. (Just saying, some technically valid scenarios should be taken into account)
Despite the category mismatch (continent vs country) .. Europe and USA have very similar population densities (~35 p/km2) [0] [1] [2] [3]

Also, many sparsely populated European countries have relatively good internet speeds (eg Iceland, Sweden).

[0] https://database.earth/population/europe/density

[1] https://www.worldometers.info/world-population/europe-popula...

[2] https://www.worldatlas.com/articles/european-countries-by-po...

[3] https://data.worldbank.org/indicator/EN.POP.DNST?locations=U...
Ever heard of Edward Snowden by any chance?
With the shift from CD to streaming I'd strongly suspect most people just use a smart speaker setup.

I fall into that category too with Sonos. The speakers were relatively expensive but now they're not the latest model I bet they wouldn't be worth much second hand.
99% of Iran's 300 missiles and drones intercepted
I was reading murder Wikipedia the other day and one of the guys got out of prison the second time and was able to pick up a job making 1k/week in the late 70’s (49-50k/year) in SoCal.

That’s what I was making a decade ago in SoCal with a college degree (slightly more with OT).

Ohh to live the life of an uneducated violent offender in the 70’s.

https://en.m.wikipedia.org/wiki/Lawrence_Bittaker_and_Roy_No...
I work at a business that sells a product built on Intel SGX.
OEIS is perhaps the best model. I'm not sure if Neil Sloane looks at every sequence that goes in but he approved my entries. It's now in a trust and will definitely continue once he stops contributing.
In our quest for personal growth and success, it's often the small, consistent actions that yield the most significant results over time. Just as a drop of water can eventually carve through stone, daily habits, when practiced consistently, can lead to remarkable transformations in our lives. Here are 10 good habits that, when done every day, create a compound effect, propelling us toward our goals and aspirations:
Although what goes up can come down... if some other state or region within California permitted large amounts of construction, enabled businesses to move in, and threw a few hundred million at building a great university, property values here would drop a lot.

With less intention and planning it will take longer, but could still happen, and there are some natural pressures pushing things in that direction.
You imagined some meaning not present in the words I wrote, and asked me if that’s what I meant. This is a way of implying that my words had this imagined meaning. You should avoid doing that.

Contract law does not explicitly state that every provision of every contract must always be followed. By definition, contract law really has nothing to do with the specific circumstances of any particular agreement; if it did, it would just be a law about those circumstances and not about contracts. In fact, it was not until two years ago that a court acknowledged that the GPL really is a contract (https://sfconservancy.org/news/2022/may/16/vizio-remand-win/).

All I am saying is that you shouldn’t ask them not to try to weasel out of their obligations under “the law”, but instead to ask that they not try to weasel out of their obligations under the terms of the AGPL. This is a contract that they entered in to not just with the authors of the open–source software that they rely on, but also with their users. It would be dishonorable to renege.
https://en.wikipedia.org/wiki/Daytime_running_light

For a car that has DRL enabled, you’ll be able to tell that the car’s engine is running by checking to see if head lamps are on.

It’s especially useful check for (stationary) cars during the day when you are at a distance where the engine’s sound is inaudible.
The problem is product/market/financing; not in personnel or organisation.

Airbus and Dassault are doing fine because they have well defined stable markets and (probably) government funding.
Tech exec predicts billion dollar AI girlfriend industry
> We need a concept for debasement / hidden tax that allows people to hold their policymakers accountable.

This is a really good idea and I hope someone popularizes a new measure.
> First, US medical school graduating classes are smaller in number than the number of available residency positions.

That's because the artificial restriction is placed on entrants to study, not qualified post-study graduates.

And it really is a purely artificial restriction: in the 90s, in SA, when affirmative action was implemented (where a C student from a particular background would get placed before an A student from a different background) didn't result in any measurable difference to the resulting quality of doctors.

We literally have a small experiment showing that allowing C students into med school doesn't affect the outcomes, and yet there is still a very limited intake into medical schools, and this is purely an artificial limitation.
Anyone happen to know how this program got funded by Horizon?
Paul Krugman. Damn…
dexter uses a similar premise with hypog.

https://github.com/ankane/dexter
What? Upppercase and lowercase occupy the same amount of bits. ASCII uses 7 bits for all characters (although in practice 8 bits).
It's also made by the top contributor to erg (github user mtshiba), and erg is trying to be a compiled typed python.

If you're already making that then building a type checker wrapper on top of it makes perfect sense.
Μy favorite example of mathematical typesetting on the web. I sent them some emails asking for directions to mimic their design for my personal webpage, but did not get any replies. My crude attempt at web mathematics in that style is here: https://ykonstant1.github.io/power-draft.html

But I would love if they made a tutorial or blog post describing in simple terms how to get a design like that going; many many professors could incorporate that and make mathematical resources much easier to access for students. I always have an online Class Diary for my classes, and my students would love to have rendered equations directly in the webpage.
Problem with selling developer tools is that devs have no purchasing authority
That's missing forest for the trees. The more important part is that average 3.7 people household was a single-income one.

I would rather disagree with GP's:

> My point is that inflation isn’t abstract and it isn’t a law of nature. It’s a deliberate approach to stealing your prosperity while you cheer it on.

A lot of the inflation, including how suddenly a single-income household isn't a viable option for most people in the West, is market working as intended - quickly consuming any surplus money, should it suddenly become greater than 0 on average, and slowly eating into any value that isn't bare-minimum strictly necessary to move a product.
Better quality than this?! Can you link to a picture you think is lacking?
There is an admirable maturity and wisdom in understanding the scope of your life and what is important, and working to make the world as you wish it to be within those confines. Too often we aggrandize ourselves by spending time worrying about the problems of the world far beyond our control and do not try and address them in the realms in which we do have some sway.
People with more money 'struggle with generosity,' expert says
Beautifully written. For some reason, Beatles' Eleanor Rigby sounded in my head while I was reading this...

"All the lonely people

Where do they all come from?

All the lonely people

Where do they all belong?"
At least with a monolith, all of your ball of mud is in-process.
In America? Get ready for more road rage shootings
He had to serve in Germany during the Korean war. Still he got called up and posted away from his home, so you still have a point. I think it was people born in 1950 that had it easier, especially in the UK, since we didn't go to Vietnam.
I absolutely cannot stand Office. Word is basically acceptable, but I refuse to use PowerPoint unless absolutely forced to. The major problem though is that every single component is blighted by the Ribbon, which among all the bad things that Microsoft has done is the worst.
this is our posture for this extension on the supabase platform. we could automate the creation of the indexes using the Index Advisor, but we feel it would be better to expose the possible indexes to the user and let them choose
Moulden was a snake-oil peddling quack with a degree in psychology who was never licensed to practice medicine. He peddled something called "BrainGuard" that purported to diagnose autism by looking at a picture or short video of a child or even a baby.

https://web.archive.org/web/20100109213523/http://brainguard...

> YOU are Now the Expert: Now You can diagnose vaccine induced Alzheimer’s dementia (or autism) several years before the Medical Doctor’s do – amongst your family and friends. You can also diagnose Autism (as it is is happening) in newborns, babies, teens – common signs. LOOK here to learn and practice your skills – starting

He also hooked up with something called therapies4kids to peddle a suit that could somehow cure or alleviate autism: https://web.archive.org/web/20090925065222/http://www.therap...

https://vaccineconspiracytheorist.blogspot.com/2011/01/quack...

https://hatingautism.blogspot.com/2009/10/dr-andrew-moulden-...
> We always extract json. We don’t need JSON mode,

Why? The null stuff would not be a problem if you did and if you're only dealing with JSON anyway I don't see why you wouldn't.
Go + Bash is my goto as well, for "bare metal" DevOps work. That's what I would think too, one of the whole points of the JVM is to skirt that issue. So I was interested to see if I had missed something here.
I don’t know, try to explain your point of view to people like Trump or Musk.
[1] https://2coffee.dev/en/articles/note-taking-app-notas

[2] https://2coffee.dev/en/articles/diary-of-making-notas-first-...

[3] https://2coffee.dev/en/articles/diary-of-working-on-notas-pa...
Yes, I don't trust the state's either. But we have to keep things in proportion. Europe can't throw its efforts and forces now at trying to become independent from the US.

We first have to defeat Russia, China, etc. Become independent of them and even defeat them before we start trying to peel off dependency on the US.

US is an ally, and in the near future we have to rely on them. That's it.
Plenty of businesses are closed on Sundays. Even closing a website on Sundays is not unprecedented.
Check My Math – Nix vs. the Most Complicated Program on Earth
The sad thing is that there is an optimal number for working hours for employees in "potential emergency jobs". It is around 85% or so. (I forgot the source, I think it was Gerd Gigerenzer on managing risks.) This way, they can handle most emergencies in a good way.

Reality is that many doctors in a hospital work 120% already. This either kills the doctors or the patients.

The issue is that most doctors genuinely want to help their patients and feel some kind of personal responsibility and thus, can easily be exploited by the healthcare system to work longer hours. If they don’t do it, patients die, because there is no one else taking care of these patients.
Indeed it's not.

But this implies removing dependencies on various libraries, and keep a such important process small is already relevant, despite the fact that it will load PAM libraries, making it quite still prone to issues.