jhas78asd

6 ms·

1.
by jhas78asd 3y ago
PostgreSQL and Ruby on Rails. https://andyatkinson.com/
2.
by jhas78asd 3y ago
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 contributing factor.
3.
by jhas78asd 3y ago
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 meant to type psql, you could add aliases to your shell that poi
4.
by jhas78asd 3y ago
Hi Craig! :) https://twitter.com/andatki
5.
by jhas78asd 3y ago
There is a way to provide some type of planner hints https://pghintplan.osdn.jp/pg_hint_plan.html
6.
by jhas78asd 3y ago
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 Postgres. There is also a built in help. These can also be sav
7.
by jhas78asd 3y ago
Find the SQL from meta commands. Example: https://dba.stackexchange.com/a/131031
8.
by jhas78asd 3y ago
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/131031 I also highly recommend investing i
9.
by jhas78asd 3y ago
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 you have tables that are smaller than a TB and a large memory
10.
by jhas78asd 3y ago
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 to their own database (aka functional sharding/vertica
11.
by jhas78asd 3y ago
Did you implement table partitioning with Postgres or consider that before moving?
12.
by jhas78asd 3y ago
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 the parent (that propagated to children), if we aborte
13.
PostgreSQL Zero Downtime Primary Key Conversion(fountain.engineering)
4 points by jhas78asd 3y ago|3 comments
14.
by jhas78asd 3y ago
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, so we had to use some tricks to pull this off.
15.
by jhas78asd 3y ago
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 their hiring process. Find out how we used PostgreSQL table part
16.
PostgreSQL Table Partitioning – Growing the Practice(fountain.engineering)
1 points by jhas78asd 3y ago|1 comments
17.
Puny to Powerful PostgreSQL Rails Apps(andyatkinson.com)
1 points by jhas78asd 4y ago|1 comments
18.
by jhas78asd 4y ago
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 supplemental content page with examples. Feedback is appreciated.
19.
by jhas78asd 4y ago
https://andyatkinson.com
20.
by jhas78asd 5y ago
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 Rails. https://github.com/ejschmitt/delayed
21.
by jhas78asd 5y ago
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 frequency idea and the entropy discussion and have more ideas. ht
22.
My Ideal Coworking Spot as a Remote-Based Programmer(andyatkinson.com)
2 points by jhas78asd 7y ago|0 comments
23.
by jhas78asd 9y ago
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 IMO to being with). My wife attended a Big 10 university med