Viewing profile — jhas78asd

PostgreSQL and Ruby on Rails. https://andyatkinson.com/

Any posts on this? Are there bulk data loads that make table stats more stale and affect plans? I’m wondering what would suddenly make a plan selection change a lot that might be a…

If you’re talking about the command line client that’s built in, it’s psql. If you can’t remember the command name to launch it or regularly type those other commands when you mean…

Hi Craig! :) https://twitter.com/andatki

There is a way to provide some type of planner hints https://pghintplan.osdn.jp/pg_hint_plan.html

Each of the bullets you listed have very straightforward and memorable meta commands that I use on a regular basis with psql. It may be worth learning them just for when you use Po…

Find the SQL from meta commands. Example: https://dba.stackexchange.com/a/131031

You can likely get the SQL for a meta command, and you could run the SQL from your preferred client if you don’t use psql. Here is one example: https://dba.stackexchange.com/a/1310…

What’s the reason though for Vitess? Postgres supports tables up to 32TB but hopefully you’re splitting them up using declarative partitioning in one or more ways before that. If y…

Thanks for calling out table partitioning. Besides implementing it at one level, multiple levels can be used simultaneously (eg list and range). Tables can be grouped and split out…

Did you implement table partitioning with Postgres or consider that before moving?

We didn't write up our rollback plan, but here was the gist. Since we first had to remove the primary key from all children in order to add the conflicting composite primary key to…

In Part 2 of this 2 part PostgreSQL Table Partitioning series, we'll focus on how we modified the Primary Key online for a large partitioned table. This is a disruptive operation, …

Recently we faced a challenge working with a large table where query performance had worsened. This is a high growth database table that tracks applicants as they move through thei…

This talk covers 5 challenging areas when scaling Rails applications on PostgreSQL databases. Slides and a video recording of the presentation are available, as well as a supplemen…

https://andyatkinson.com

I helped maintain delayed_job_web as a UI. It has fallen behind substantially now though. If folks are looking for a UI - it would be great to update it for modern versions of Rail…

Fun. I spent an hour and made this and just tried to score words with vowels and wheel of fortune consonants to start to make a good initial guess. IRATE came up. I like the freque…

The article failed to mention the high cost of medical school, high interest rates for loans, and being phased out of interest deductions from earnings (which are capped quite low …