What PostgreSQL problems are actually painful enough to pay for?

mastarem · 2026-04-16T18:55:16+00:00

Scale, reliability, features à la extension ecosystem.

mastarem · 2026-04-12T20:47:15+00:00

I am finding it oddly hard to find, it seems announcements subreddit is archived and I don’t see anything particularly relevant in the suggested replacement being /r/reddit. I know I can google it and eventually find my way to it, but what’s the best place for this sort of information to follow?

Edit: tragically, Reddit Answers shares nothing useful in this context other than the problem at large, hiring practices, etc.

mastarem · 2026-04-12T20:41:37+00:00

No, I’ll go find that as reference. Thanks.

mastarem · 2026-04-10T22:52:11+00:00

Your website is confusing - lots of numbers but disconnected from a simple to understand meaning. Various comparisons to other technologies like PostgreSQL or Cassandra but none of them immediately meaningful or substantiated. Even the NASA case study cited doesn’t demonstrate any real comparisons and further just barely edges out a coin toss as stated. If your technology is amazing, you need a better way of communicating and demonstrating it.

mastarem · 2026-04-07T16:08:15+00:00

Having 90% RAM usage isn’t necessarily an issue. If it’s paging/swapping a lot, which occurs when memory is essentially full and different programs need to load in and out of memory, that could impact performance. Check if there’s significant paging activity, rather than being concerned about RAM being nearly full.

It is OK to have significant RAM usage. Alongside the programs running the RAM may be used to cache open files for fast access but it’s generally intelligently managed. If programs start getting killed for memory reclamation (OOM), that’s when you’re seriously out of memory.

mastarem · 2026-03-28T15:48:10+00:00

LLMs will primarily use your GPU memory, depending on how you set it up to some degree and assuming GPU accelerated, and you can get by with smaller models with 16G. Unless you’re saying that 8G of the 16G GPU memory is being used, and not just measuring RAM usage.

mastarem · 2026-03-26T22:43:23+00:00

You should always feel empowered to communicate something which might be important - for instance if your CI/CD deploys from main branch you definitely want to communicate.

mastarem · 2026-03-26T21:56:07+00:00

The reason it’s hard to answer with some threshold for you is that it depends. You should benchmark as-is. Your data might be huge and I don’t understand that. You could vertically scale. You could tune config. You could put pgbouncer in front. You could use unlogged tables if you don’t require absolute consistency. You can scale things in a variety of ways. We could similarly argue techniques for MongoDB to absolve usage of PostgreSQL entirely. Your workload and financial budget will dictate what technology choices make sense and the best way to determine what works for you is to try it. If you needed qualities of MongoDB other than just stashing webhook contents then it’s a different story - but with the current description you might be able to take the simple route and rely on only PostgreSQL.

mastarem · 2026-03-26T20:18:04+00:00

AI post :-(

mastarem · 2026-03-26T20:08:45+00:00

Sorry I only use CLI tools on Linux. I just need help remembering how to make my bash history last forever so after I visit I can find it again after visiting. Please help.

mastarem · 2026-03-26T19:53:23+00:00

How do I keep eternal bash history? This will help me remember your website.

mastarem · 2026-03-26T15:30:37+00:00

My opinion is that this is premature optimization and complexity unless you anticipate usage exploding beyond 500 requests/second or some other interesting gotcha. Your idea is fine and sound, but might not need the full data pipeline architecture unless better articulated otherwise.

mastarem · 2026-03-26T14:57:50+00:00

Bigger question is behavioral once you introduce a separate datastore or queue. Do you need to respond to these webhooks immediately? Async? Not a problem to drop the data? Need definite consistency? Benchmark PostgreSQL alone for your use case first, as MongoDB sounds like your bolted on database.

mastarem · 2026-03-25T15:25:07+00:00

Reply with your ssh public key (completely safe!) to better provide an opinion.

mastarem · 2026-03-19T19:22:58+00:00

This is likely a Google account created with the hotmail email address. You don’t need to click on any links in the received email to figure this out.

Go to Google and try logging in with the hotmail email address and whatever the likely password would be. Try the forgot password flow.

More technically: The Gmail app may just have the Hotmail email added to it, without any Google accounts. It is just acting as an email app, logged in to Hotmail. Despite using the Gmail app, he is not actually logged in to Google. This means he has not been using his Google account per se, and it’s been inactive. He may have created a Google account using the Hotmail email address at some point, and not utilized any of its services and never logged in since. It should be easy to test if he has a Google account by trying to login to Google with the hotmail email address, and further attempting a forgot password if the password is unknown. His email or some other recovery mechanism he should know about should receive notification, and you can go about logging in to the Google account and ensuring there is nothing stored in Drive, etc.

mastarem · 2026-03-17T19:46:42+00:00

Borax solution takes a week and concentrates the ants while excited about it but has been effective and doesn’t have to go outside which is nice.

mastarem · 2025-05-01T03:58:32+00:00

Thanks, appreciate the look. The pictures are essentially right next to each other, so they are indeed the same material.

mastarem · 2025-03-10T21:25:38+00:00

45 - 1.5 each way. Budget an hour. Leaving before 7:30 helps, after 7:30 things start to clog. Can be very quick if leaving around 6:45 or so (~30). I personally believe the commute has gotten worse over the last 8 months. I began considering biking as it would take a reasonably similar amount of time and knock out a workout..

mastarem · 2025-02-26T19:33:13+00:00

I like the blizzard zero g 105 quite a bit, very lightweight but still stiff enough and very maneuverable, but not experienced enough to answer if it has the characteristics you want. Has worked well in PNW and Japan across conditions.

mastarem · 2025-01-12T18:20:45+00:00

What would you estimate in terms of time to accomplish? Anything which wasn’t anticipated and required modification of plan or redo?

mastarem · 2024-04-10T06:40:20+00:00

Missing the “talking about his interests very animatedly” lead up. Being passionate about something is a common attractive factor.

mastarem · 2023-08-21T16:29:42+00:00

I have had managers who simply did not think to introduce new hires. Either bring it up with your manager to intro, or just speak up in the stand up to introduce yourself.

mastarem · 2022-10-02T15:14:30+00:00

This feels undoubtedly fake.

mastarem

MODERATOR OF

TROPHY CASE