It has been tried many times. Good luck to pgdog, but there’s a reason these projects don’t stick.
Multi master, from even a conceptual perspective, is incredibly complicated. Databases, transactions, consistency, parallelism are all very complicated.
It’s something that always seems promising at the start but as soon as maintenance and long term improvements enter the picture(ie integrating new Postgres versions), the complexity becomes too much.
No one is taking away the existing automatic planning that works well 95% of the time. You're welcome to continue using that.
The worst thing that could possibly happen is that you give it bad advice leading to slow queries, and then the obvious first step to fixing that is to drop the manual advice and see whether the automatic planner handles it better.
It baffles me that PostgreSQL, which is so deeply customisable in almost every other way, resisted this form of customisability for so long. This is great news.
We are basically dealing with the fallout of the 2008 GFC bailout to this day.
The fiat economic system is irreparably broken, and we are circling the drain. Another bailout is _probably_ inevitable. But the cycle sure as hell isnt resetting and we are speeding towards something... what it is is unclear though, and when is also unclear.
The part people cant wrap around is the scale of it and the time it takes to go through the super cycle. Theoretically, it all started with the Dot com bubble, which indirectly cause the housing bubble, which caused the GFC. Which caused whatever happened in 2019, which caused QE in 2022 under the guise of COVID, which is causing whatever the hell is happening now.
Capitalism has become uncorked, and money is irreversibly flowing to the top at an increasing rate. The logical next stage is that like 75% of the world's population is literally not even part of any economy. And that doesnt really make any sense
yeah I intuitively have felt something like this has been happening, too. And finding the evidence is such an immense task, and feels way out of my current energy level.
When COVID was ongoing there was a term floating around I liked, "Psychosis" was it. The spell is like that of, denial? Terror & shock?
Trauma might be better?
Looking at trauma responses and how to detect it in humans is an interesting perspective to look at all this with. Personally, if I look at it from "people are afraid, traumatized, defending themselves" and use that to extrapolate how most people (the masses, the non-rich) would act and also the rich - that points me to why theres such a sudden hastening of action and pace of wealth up towards the top in the name of AI & war.
Sigh, no. Money is not flowing; company valuation might be, but that's temporary and only works if the company keeps delivering insane amounts of value.
So the founders sell plenty of stock while the price is high and then when their valuation crashes sure they "lost" half their net worth but the other half is still there.
I'm not saying that's what's happening, just making it clear that company valuation not being permanent is not a valid argument against money flowing to the top.
I don’t think that’s it. I think the only thing that motivates billionaire is just to have more than the next guy.
The only thing that motivates Bezos is that Elon Musk’s has more and conversely Elon Musk would have a existential crisis if he was no longer number one
Companies whose main core competency is writing code were already making up a big chunk of the economy before AI. Also, less wealthy companies were constrained in their use of software by the inability to afford the salaries of talented programmers (and ripoff practices from software consulting companies who in theory could help). Lowering the cost of building software systems ought to unblock a good amount of economic activity as the technology diffuses.
Those companies are certainly writing more code. But It isn’t clear that they are increasing their economic productivity. It could even conceivably have the opposite effect by fueling a race to the bottom.
e.g. an interesting possible canary in this coal mine is that there’s been a 200% increase in the rate of new apps appearing on Apple’s App Store, but it has not been accompanied by a 200% increase in the rate at which people are buying apps.
The AI pundits often seem to apply the logic that code output is directly proportional to revenue and/or profit, and as such it follows that an AI usage increase leads to more code which leads to more revenue.
I don't believe this aligns with the reality of any major company, unless your business is in the literal sense "selling code" your revenue and profit is tangential to the quantity of code you produce. Google is a good example of this: most of their revenue and profit comes from their ad network, which is disconnected from their development productivity and instead heavily reliant on network effects and time in market. If I was a new competitor with infinite AI funds to throw at whatever problem I choose, I can't simply capture their market by developing an exact copy of Google's ad platform. In the same way, Google can't substantially grow their ad network by coding "more" or "better", they still need more customers and consumers to interact with their network to see any increase in revenue.
So it doesn't directly follow that a productivity increase will inherently follow an AI usage increase.
Agreed. I think it’s more likely to expect that most of it is pure waste.
My impression is that most software development work is not profitable. Either the project is abandoned, or it fails, or it gets shipped but doesn’t generate positive ROI. But, like how venture capital works, the minority of projects that are successful make enough money to cover the rest.
Some portion of this is because demand for software projects in general is less than perfectly elastic. So more software does not automatically mean more software sales.
It also seems plausible that, in general, companies tend to fund the projects that are most likely to be profitable. They aren’t perfect at it, but I doubt they’re just rolling dice.
Which would imply that the new work companies can take on thanks to developer productivity gains will tend to be ones that are less likely to generate positive ROI.
meaning AI may only produce a net increase in waste, which only serves to erode profits.
Add to that that it’s been years now and we still don’t have an example of someone army-of-oneing a killer app or anything like that. It’s beginning to feel like another iteration of the amazing blockchain revolution that was always & forever just around the corner.
The unlocked economic activity won’t come from a Google competitor writing code faster. A lot of it will come from “boring” businesses who could benefit from custom software but haven’t had the means to create it themselves. In some cases they may not even know their problem can be solved by software, but some AI they are using for repetitive tasks will notice and offer to build an app for them.
I would go as far as to say writing more Code has almost no impact on their economic productivity. What drives those companies is infrastructure and networks
So far the place where I've seen "more code being written" having a postive effect, has been in paying down tech debt and reduction of overhead. We've rewritten services (bringing multiple microservices back under moduliths) and cut costs. But I'm talking about net-negative code. That's not the point you're making. I agree that puking out 20 new features likely wouldn't gain us more revenue.
If the quality of all apps remains high, but if there is an increase of low quality apps it may not necessarily be great for consumers as it becomes difficult to distinguish which are the good and bad quality apps, making it risky to purchase apps.
I am yet to see that ‘companies with great ideas which simply cannot afford those very expensive developers’. For the most, issue is not programmer costs. Mostly it’s inability to formulate the MVP which makes sense.
‘uber for my industry’ is not a sensible business strategy
Honestly, if you know guys whose bottleneck is pure software dev — please let me know, I have a good, experienced team in Eastern Europe, we can do wonders in product development. But coming up with sensible business ideas and executing on them in the real world is crazy hard and extremely rare.
Can you believe that the barrier to entry on a $20 Claude subscription is lower than emailing a guy to hire a team for a project you haven’t even thought of yet? Regular people who are using AI to assist with their daily work will find the chatbot offering to build software tools to automate the work for them.
You are wrong, sir. Their core competency is building out infrastructure and networks to support their software and user base. software is by far the least complicated thing they do.
what makes YouTube YouTube is not the video player it’s the servers that can handle petabytes of uploads a day and billions of views. YouTube software wise, is no different from the 100s of porn websites that are coded by small European teams
But what if it kills current ad-tech as we know it (paying to show ads on random sites without any way to verify that the site is legit), and the flow of ad money for legitimate goods turns back to journalism, magazines and other publications?
That would be half a trillion[1] redirected to regular people just from Google Ads.
The other day I watched a YouTube video on a work machine with no history and got 2 AI generated video ads for scam products before the video played.
An AI generated man talking about his product building journey to make a pressure washer hose that didn't need power (in the AI video it didn't even have a water supply connected!) that was going to be banned in a week because it was too powerful so buy now.
I've seen AI slop before and scam ads before but the combination of the two gave me some real tingly spider-sense that things are going to get worse and that some unethical people will make a lot of money from it so be in no hurry to stop it.
I mean, that says a lot about the kind of crisis out current economy is in. How much longer can the United States Be a world leader when it’s primary function is social media and advertising
Advertising is huge because it's backed by a ton of very real products that people go and buy. It matters because people don't automatically have awareness of things they could find useful.
And writing code is one of the most economically productive activities you can do. Why is it controversial that a technology is good at this?
That value for advertising goes negative on a marginal basis.
The first time (or few times) you saw an advert, you were informed of the product's existence. I now know the Hyundai Elantra exists and could potentially be suitable for my vehicle needs. Mission accomplished.
The next 10,000 times it's just fighting over share of a finite market. I am not expecting to buy another car for another few years, so reminding me that I can choose an Elantra instead of a Corolla at all times is just vapourising cash. In fact, there's a chance that you do something obnoxious in your ad and actively burn brand reputation.
You could argue it's a take on the "everyone uses a different 5% of the features" problem-- that advertisement is going to be within the first "informational" window for someone, but maybe there are more efficient ways to not blast it at uninterested audiences.
One other angle might be asking if we still need some markets to be competitive in the first place. You don't need ads if it's a "when you need X, you'll know where to find it" sort of product. If we nationalized the insurance industry alone, we'd probably eliminate a detectable percentage of ad volume.
People really think we have found a way to negate the laws of physics. As of there can exist a system without entropy.
Humans are prisoners of the present moment, but just think what a market is. What does it really mean as it accumulates disorder for decade plus.
Can the market just continue to deviate from a markets actual purpose forever? Hell, can anything in this universe exist in a particular state forever.
If it can’t, then it means at some point things have to go in the other direction. Use your imagination what that means for the largest most complex (man made) system in the history of this planet.
Money and economics are not “physics”. They are social constructs and not immutable natural laws. Prices can go up as long as people are willing to inflate PE ratios; this isn’t the same as saying my weight will increase indefinitely because acceleration due to gravity increases.
If you’re typing 100s of lines, you’re already doing it wrong. My most used operation is completion, just before copy-paste. The reason I like vim is that it makes such operation so fast. And the reason I like emacs is that it has superpowered version of those operations.
Multi master, from even a conceptual perspective, is incredibly complicated. Databases, transactions, consistency, parallelism are all very complicated.
It’s something that always seems promising at the start but as soon as maintenance and long term improvements enter the picture(ie integrating new Postgres versions), the complexity becomes too much.
reply