News for hackers. Stuff that matters.

A comment on Migrating to Postgres. Parent comment

Re:Migrating to Postgres by ScalaHanSolo on Wednesday May 14, 2025 @09:21PM (#43990897)
Author here. Optimizing bad queries was absolutely part of the issues with the performance. The issue with cockroach was that the visibility into those bad queries was not great. It wasn't until we had the superior tooling from the Postgres ecosystem that we were able to track them down more efficiently.
[ Parent | on HN ]
Re:Migrating to Postgres by compton93 on Wednesday May 14, 2025 @09:25PM (#43990925)
When you get a chance can you take a look my reply here: https://news.ycombinator.com/item?id=43990502

When I first stepped into a DBA role with CockroachDB I was confused why indexes we obviously need were in unused indexes. It wasn't until I did an explain on the queries I learned the planner was doing zig-zag joins instead.

[ Parent | on HN ]