Viewing profile — andatki

Happy to discuss any details from the post. Thanks for taking a look.

https://andyatkinson.com

If merging or moving data between environments is a regular occurrence, I agree it would be best to have non-colliding primary keys. I have done an environment move (new DB in diff…

Great!

Good addition!

This was written based on working on several Postgres databases at different companies of “medium” size as a consultant, that had excessive IO and latency and used UUID v4 PKs/FKs.…

Appreciate it!

Note that if you’re using UUID v4 now, switching to v7 does not require a schema migration. You’d get the benefits when working with new records, for example reduced insert latency…

Hi there. Thanks for the feedback. I updated that section to hopefully convey the intent more. The type of ordering we care about for this topic is really B-Tree index traversal wh…

Good point that the post should be made clear it’s referring only to my experience with Postgres.

I’ve used Marp a lot and it’s great. Column layouts and code highlighting are two features Presenterm offers that I don’t think are available in Marp.

What sorts of skills are you looking to build? Since this post has a lot of comments about query optimization, I’d suggest query optimization is more in the realm of developers and…

Nice post covering many of the main ways to improve efficiency. Here’s a related post I wrote for AppSignal: What's Coming in Ruby on Rails 7.2: Database Features in Active Record …

What a name! - A dot Atkinson

Rails and Postgres (and AWS) was the pre-acquisition stack, and development continued with that stack during this time period (2020-2021). https://en.wikipedia.org/wiki/Flip_(softw…

Hi there! That's funny! This interview and those gem updates were unrelated. However both are part of the sweet spot for me of education, advocacy, and technical solutions for Post…

Great list of Postgres features called out that highlight the extensive feature set. Most of these are covered in my book, for anyone that’s interested in learning them. The book u…

Newer versions of Postgres also support dropping indexes concurrently. I recommend using the concurrently option when dropping unused or unneeded indexes on any table with active w…