Viewing profile — jashmatthews

If it works for you it’s great but the RDS EBS limitations are real enough… AWS built Aurora and for RDS a new 3 node topology using local SSDs for writes and EBS only for the data…

Most companies can afford not to give a shit until they hit SOC2 or GDPR compliance and then suddenly orphaned data is a giant liability.

Does vacuum not release free pages at the end of an index file in the same way it does for the heap?

> hybrid OLAP+OLTP .... in Postgres this pattern requires careful planning to avoid falling afoul of max_standby_streaming_delay for example This is a really gnarly problem at scal…

Make friends with lawyers.

Purely vibes but as a Kiwi I feel like Number 8 Wire mentality has been dead for at least 20 years now.

Symbols have been GCed since CRuby 2.2 https://bugs.ruby-lang.org/issues/9634

Can we demonstrate them doing that? Absolutely. Will they fail to do it in practice once they poison their own context hallucinating libraries or functions that don’t exist? Absolu…

Hallucinations are now plausibly wrong which is in some ways harder to deal with. GPT4.1 still generates Rust with imaginary crates and says “your tests passed, we can now move on”…

The USA hasn’t managed to completely impose their idea of intellectual property on everyone yet. Some countries you can’t sign away authorship even if you can commercial rights.

Yeah the older Pilot Sport tyres wore out quickly. I had PS4 before and now PS5 and they are wearing at something like half to a third as fast? Very happy. Only slightly less grip …

My understanding is the way Aurora DSQL distributes data widely makes bulk writes extremely slow/expensive. So no COPY, INSERT with >3k rows, TRUNCATE etc

Hey Lev! I've been looking into PgDog for sharding a 40TB Postgres database atm vs building something ourselves. This could be a good opportunity to collaborate because what we nee…

Exactly that. It's an arms race between companies that offer a large number of residential IPs as proxies and companies that run unauthenticated web services trying not to die from…

It’s simple high throughput queries that often bite you with the PG query planner.

AWS claims 10x lower latency but I haven't personally checked.

While technologically cool the app is bullshit. 90% accurate isn't accurate enough for the job and it's effectively making shit up. Are you eating a 10% calorie deficit or a 10% ca…

If you round up great engineering orgs that ship impactful stuff more of them don't use JIRA than do. Linear, Basecamp, Asana, Monday etc. My experience is by the time an org gets …

Intelligence is kinda unnecessary at this point. A Tiktok VP already admitted to a UK parliament select committee that they used to harshly moderate anything the Chinese government…

When humans learn and copy too closely we call that plagiarism. If an LLM does it how should we deal with that?

Clustered tables and sequential keys have their own downsides though like lock contention on the "last" page.

There are a bunch that offer strong consistency e.g. Cloud Spanner and DynamoDB.

It look like a decline but these are relative numbers right? The whole industry exploded in size over this time period.

Competitive pressure on SaaS companies and startups is much higher now and while there are tons of people are building client wrappers and other much more exciting stuff in Ruby no…

Best to just forget about it and listen on a connection not using pooling. https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html#lis...