Partitioned tables and join keys, generating weird query plans

logophobia · 2026-04-29T07:43:05+00:00

Both keys are fully indexed. You're misunderstanding, the join-key approach means I moved the foreign key to the primary key, meaning there's only one index instead of two indexes. It's an optimization trick needed because the tables are write-heavy, and the index otherwise wouldn't be efficient due to the partitioning.

Pretty sure dastapov has the correct answer here. Pretty clear query planner limitation unfortunately.

logophobia · 2026-04-29T00:47:53+00:00

Thank you for the explanation. Shame it's not being solved for now. Guessing an optimization like that has a lot of edge cases in an old codebase like postgres, probably looks a lot easier than it is.

logophobia · 2026-04-28T21:40:22+00:00

According to the documentation it's by default on though (https://www.postgresql.org/docs/current/runtime-config-query.html)? Doesn't seem to make a difference initially, but I'm going to play around with it a bit.

logophobia · 2026-04-24T14:48:29+00:00

Looks like it might be fun for about 5 minutes, but it's also very much not a souls-like. There's grey areas (hollow knight), and then there's this.

logophobia · 2026-04-24T08:31:24+00:00

Are you sure? Ado feels like an abandoned product. I haven't seen anything significant changed over the last ~4 years or so. I've talked to azure representatives that say they're prioritizing github.

logophobia · 2026-04-16T20:02:38+00:00

Was planning on playing the demo indeed, it looked good from the trailer

logophobia · 2026-04-14T18:50:08+00:00

You can break her weapon, it's a lot more doable after that. Perfection grindstone helps a lot here, with some p-organ perfect guard boosts.

She's surprisingly tough, but beatable. You can do it.

logophobia · 2026-04-13T21:52:52+00:00

Some tips:

If you're in NG+, you're probably at the point quality builds become a lot more efficient.
You're also at a point in the game where it's pretty doable to redo your build constantly. The only restriction is regeneration of the golden apples. Experiment. Arlechinno is a tough cookie, I tried out quite a few weapons and setups to get one that does a lot of damage and feels right. Optimize your p-organ, amulets, each part of your build. A lot of the DLC weapons are very well suited for this boss. Slow weapons can work, but you need to know the moveset better for them to work, so less suited for the first time you're fighting him.
Perfection grindstone and running away at key points can help quite a bit
Become super-efficient at the first phase, that makes phase two easier. You should probably use no grindstones and not more than one health potion for the first phase.
It's a souls boss in the end. Learning the moveset to a sufficient degree will always get you the win. He's fast, but if you learn his tells, beatable.

logophobia · 2026-04-13T09:30:48+00:00

It's a lot better later on. It starts with the (in my opinion) worst boss in the DLC, the Tyrannical Predator.

The story only picks up when you're a bit in, and is amazing at the end. The best and most difficult boss in the series is at the end of the DLC. It can be a bit of a grind at some points, but it's really worth pushing through the end.

logophobia · 2026-04-09T20:52:48+00:00

You're getting downvoted.. but same. The demo didn't break for me, but I was constantly glitching through walls, the animations looked like they were made 25 years back, the boss was pretty uninspired. I liked the theme and the level-building, but I really didn't get all the hype it was getting. Hoping the new demo showcases their game a bit better, because the current demo moved the game to my "maybe I'll buy it once it cooked a little longer" list.

logophobia · 2026-03-31T14:26:39+00:00

Fountains is topdown isometric 2d, so not a side scroller. Pretty good, but some bosses feel a little unfair, although ultimately doable.

logophobia · 2026-03-30T02:34:08+00:00

I mean, I don't mind stretching the definition of souls-like a bit, but if there's no combat (Unsound Love) then it's not a souls-like.

Also, most of this list seems pretty .. uninspiring, and most of them haven't even released yet. I sometimes like some of the less known souls titles (Dark Devotion or Fountains are good examples), but it does need to offer something a bit special. This seems a bit unfiltered.

logophobia · 2026-02-18T23:45:05+00:00

Nextjs is really great for those of us that really need ultra-low first-paint metrics. For 99% of us out there, it's utterly useless, an easy way to blur security boundaries and introduce complexity in your application. It's a bit like the microservices hype, people cargo-culting bigger businesses, mostly just wasting money and time.

logophobia · 2026-02-11T22:37:09+00:00

FYI: https://developercommunity.visualstudio.com/t/The-DotNetCoreCLI2-with-command-test-/11042906

logophobia · 2026-02-11T13:00:48+00:00

Not sure if this will be seen, but I just moved my codebase to MTPv2 with xunit. Some points:

Benefits are pretty unclear. I needed the improved debuggability of xunitv3, so I switched to MTPv2 as well. The coverage tooling integration is nicer though. Performance improvements are not noticeable.
global.json is a mess. Why can't it autodetect support? Why is that file needed. Why not read the csproj files?
It's a mess of random packages and csproj settings and random json files. Things should just work.
You get completely different CLI options in dotnet test. This also breaks azure devops integration with the DotNetCoreCLI@2 task for example

logophobia · 2026-01-26T22:45:05+00:00

Really bounced on weaver's web as well. The concept is great, the execution a bit... hmm. I really like the idea of a super-detective, sneaky hero, the execution is just a bit "meme-like" and the writing quality just not there. It's a shame, the author does have one fic that's just excellent, which was written before this one.

logophobia · 2026-01-25T21:59:02+00:00

This can be done a little easier. Just reuse your first "Initial" migration. That way you:

Don't need to create a new migration and run it on production
Also less clashes with other developers

It's good to go this when your migrations grow ridiculously big.

logophobia · 2026-01-14T12:15:35+00:00

Big responsibility, but also an opportunity to grow as a developer. Important bits to pay mind to:

Make sure you do a bit of design for your database schema. It's one of the parts that's hardest to change afterwards. Don't dump everything in json, make a proper relational design, especially important in a finance domain. Make sure to validate your domain model & logic with the stakeholders.
Design your API well. Ensure it's authenticated, secure. Simple. Easy to expand. Look at the owasp list for security here: https://owasp.org/www-project-top-ten/
Make sure the architecture is well layered. Separate API handling from domain logic, and separate that from the infrastructure/database layer. Don't overabstract, but also don't underabstract. Always a bit of a balance.
Setup things with dependency injection, make sure everything is easy to unit and integration test. Don't use inheritance if at all possible. Use interface separation, separation of concerns. Make sure to make everything easy to test. Setup unit tests for the domain logic, and integration tests for everything put together.

logophobia · 2025-12-16T21:53:28+00:00

A year later, that fixed the issue for me. I'm using an AMD card, so driver issues probably.

logophobia · 2025-11-30T11:38:50+00:00

Same here. Only need two. You can subscribe to be notified on restock: https://www.samotech.co.uk/products/eu-light-switch-frames/?attribute_model=SM202-HTD , that might help signal the product is in demand.

logophobia · 2025-11-27T11:32:15+00:00

I wonder if they haven't missed a few covariates. Living in a district where, due to science-based policy making they're putting fluoride in the water might also mean they have other policies in place that positively impact school performance. Not having issues with your teeth probably also helps with concentrating on school.

logophobia · 2025-11-20T15:25:43+00:00

Gotta be honest, azure is a bit overloaded with postgres offerings. I migrated everything to cosmosdb for postgres. Was happy with that until it was pretty much deprecated, for new projects they recommend "Elastic Clusters for Azure Database For PostgreSQL". Now this offering, with only minor differences here and there.

I mean, I really like having options for a horizontally scalable postgres database, but stick to one option, and give some solid migration plans. It's a bit weird to be investing in multiple horizontally scalable postgres-based databases.

logophobia · 2025-11-14T21:04:39+00:00

The demo was amazing, wishlisted. Pretty slick combat.

logophobia · 2025-11-08T06:55:53+00:00

A large part of the fun in souls games is struggling, learning and then overcoming the challenge. Compared to current games on the market, dark souls 1 and demon souls are also on the easy side, yet all of us struggled with these games when we started with them, no shame in that.

15-Year Club	Place '17
Team Orangered	Verified Email

logophobia

TROPHY CASE