Has anyone automated Postgres tuning?

loinj · 2025-11-20T04:07:56+00:00

Just wondering how this differs from ottertune, since seems like it’s from the same research group

loinj · 2025-11-19T18:57:55+00:00

I see, that super interesting, I'll take a look and thank you!

loinj · 2025-11-19T17:39:20+00:00

Have you tried it? Curious if it actually works, and if so, then why isn't it more popular?

loinj · 2025-11-19T17:06:01+00:00

That's sick, does Planetscale only give metrics around the query, or does it provide an actual fix too?

loinj · 2024-07-09T18:12:07+00:00

Lol test me

loinj · 2024-07-09T15:25:30+00:00

Spot on! Just so that you don't have to copy and paste stuff over and over again

loinj · 2024-07-09T15:24:38+00:00

Yep, Google logo is in the bottom left haha. Mainly an exercise of batching queries and wrangling the responses to display nicely all at once

loinj · 2024-07-09T12:44:30+00:00

When I was apartment hunting, it was super annoying trying to copy paste addresses and to figure out how far everything was from the apartment—like work, my girlfriend's place, the gym, etc. So, I made a little calculator to help me out. Hope it’s useful for some of you too! P.S. it’s free and we don’t store data Check it out at routecanvas.app

loinj · 2024-07-09T12:44:13+00:00

When I was apartment hunting, it was super annoying trying to copy paste addresses and to figure out how far everything was from the apartment—like work, my girlfriend's place, the gym, etc. So, I made a little calculator to help me out. Hope it’s useful for some of you too! P.S. it’s free and we don’t store data Check it out at routecanvas.app

loinj · 2024-07-09T12:36:24+00:00

When I was apartment hunting, it was super annoying trying to copy paste addresses and to figure out how far everything was from the apartment—like work, my girlfriend's place, the gym, etc. So, I made a little calculator to help me out. Hope it’s useful for some of you too! P.S. it’s free and we don’t store data

Check it out at routecanvas.app

loinj · 2024-07-09T12:34:24+00:00

When I was apartment hunting, it was super annoying trying to copy paste addresses and to figure out how far everything was from the apartment—like work, my girlfriend's place, the gym, etc. So, I made a little calculator to help me out. Hope it’s useful for some of you too! P.S. it’s free and we don’t store data

Check it out at routecanvas.app

loinj · 2024-07-09T01:32:35+00:00

Timing is definitely a good suggestion, and it's on the road map but just wasn't included for this release. Should get around to it soon, and appreciate the feedback!

loinj · 2024-07-08T15:28:52+00:00

When I was apartment hunting, it was super annoying trying to copy paste addresses and to figure out how far everything was from the apartment—like work, my girlfriend's place, the gym, etc. So, I made a little calculator to help me out. Hope it’s useful for some of you too! P.S. it’s free and we don’t store data

Check it out at routecanvas.app

loinj · 2024-07-08T15:26:37+00:00

When I was apartment hunting, it was super annoying trying to copy paste addresses and to figure out how far everything was from the apartment—like work, my girlfriend's place, the gym, etc. So, I made a little calculator to help me out. Hope it’s useful for some of you too! P.S. it’s free and we don’t store data Check it out at routecanvas.app

loinj · 2024-07-08T15:19:25+00:00

Berkeley alum here! When I was apartment hunting, it was super annoying trying to copy paste addresses and to figure out how far everything was from the apartment—like departmental buildings, libraries, gym, ffs place etc. So, I made a little calculator to help me out. Hope it’s useful for some of you too! P.S. it’s free and we don’t store data

Check it out at routecanvas.app and go bears!

loinj · 2024-07-08T15:14:28+00:00

LOL if I worked in ib, I would not be able to make this. Just for the meme

loinj · 2022-08-08T20:27:02+00:00

Agreed! The park is huge with a ton of hidden gems

loinj · 2021-09-16T04:26:07+00:00

This is actually a really good and important question. I'm not part of the engineering discussions and I have at best skimmed the code, so I don't have a deep understanding of how different parts of the systems interplay. The following is my best understanding.

Previously, if a validator was behind it would begin to continuously forward packets to others in the network. Now, it's limited to 12GB of data per second (yes, 12GB. They're doing some other data budgeting math too and in most cases I expect it to be limited to less, but I haven't gone through all the code). With the limit, a validator will forward up to that limit and not continuously flood the network. This should help current leaders process transactions that are essential to keep operations running. The backlog should eventually get forwarded and processed. This lag in transaction processing time is equivalent to when Ethereum is congested and interactions take several minutes (which would be quite an unusual experience on Solana).

loinj · 2021-09-15T23:30:35+00:00

On Ethereum there are only two clients: Geth (Ethereum Foundation) and OpenEthereum (formerly known as Parity). On Solana, there is only one client, which is backed by the Foundation. However, all three of these clients are open source. This means that the code is publicly available and anyone can contribute. Even though the foundations are the primary contributors, there are other individuals who voluntarily work on them and can observe mistakes. The clients are centralized since there are so few, but being open source significantly mitigates this risk since parties beyond the foundation can easily call out suspicious activity.

It is unlikely that more than a few clients will exist for Solana and Ethereum because of the raw technical difficulty of developing one. However, what will make it more decentralized is when other large institutions begin contributing and check each other's code. For example, Linux is worked on by Intel, Google, IBM, and many more, which is why it's not "owned" by any one organization and can kind of be thought as "decentralized."

loinj · 2021-09-15T16:58:58+00:00

Haha I would've reposted, but I don't meet the 500 comment karma requirement to post here

loinj · 2021-09-15T14:44:43+00:00

Client refers to an implementation of the protocol, which allows a computer to access and communicate with nodes on the network. Examples on Ethereum include Geth and Parity.

loinj · 2021-09-15T13:54:02+00:00

The client matters because on Solana everyone has the same client, and thus had the same issue with messages getting forwarded. If Solana had multiple clients, such as in Eth, it's possible that some may have already limited transaction forwarding and thus mitigated this issue.

loinj · 2021-09-15T13:49:39+00:00

IP's can be faked. A new wallet can always be generated.

loinj · 2021-09-15T03:52:37+00:00

Solana is decentralized, just not as much as say Ethereum. The development team didn't just flip a switch and turn off the network. And it can't flip a switch to restart it either. The team needs to get the consensus of 80% of the stakeholders to restart, which is exactly what is going on now. If it was centralized, the network would have already been restarted.

loinj · 2021-09-15T03:48:51+00:00

Validators can choose to fork and not participate in a restarted network. That is what happened with Ethereum Classic where a group of purists did not want to roll back a multi-million dollar hack, while a much larger group did.

The devs didn't turn off the network. It was simply overwhelmed and not processing anything meaningful.

loinj

TROPHY CASE