Rails: PostgreSQLのマイグレーション速度を改善する（翻訳）｜TechRacho by BPS株式会社
概要 原著者の許諾を得て翻訳・公開いたします。 英語記事: Better Database Migrations in Postgres 公開日: 2017/09/10 著者: Craig Kerstiens サイト: http://www.craigkerstiens.com/ データベースが成長してスケールするに連れ、気を遣わなければならない点が当初とは変わってきます。アプリをdev環境で動かしているうちは気にもかけていなかった操作コストを、production環境でがっつりと支払うはめになったりします。私たちの多くがやらかしてしまうのが、たとえばマイグレーションです。production環境でマイグレーションの起動に5分、それから15分間動き続けたまではよかったのですが、突然トラフィックに問題が生じたりします。 こういう事態を引き起こしがちな操作は2つありますが、どちらについてもダウ
Batching – A powerful way to solve N+1 queries every Rubyist should know
In this post, I’m going to tell you about batching as a technique to help avoid N+1 queries, existing battle-tested tools like Haskell Haxl and JavaScript DataLoader, and how similar approaches can be used in any Ruby program. Here is a translated Japanese version of the blog post. What are N+1 queries?First, let’s find out what N+1 queries are and why they are called that. Imagine, we have 2 SQL
Faster Rails: Indexing Large Database Tables Without Downtime - Semaphore
Chief Architect at Semaphore. A decade of experience in dev productivity, helping close to 50,000 organizations with operational excellence. This article is part of our Faster Rails series. Check out the previous article about proper database indexing. As the scope and size of a Rails project grows, actions that were blazingly fast can become slow, and even downright unacceptable. The cause behind
Common Rails idioms that kill database performance
Common Rails idioms that kill database performance By Starr Horne on Jan 3, 2017 I remember the first time I saw rails' ActiveRecord. It was a revelation. This was back in 2005 and I was hand-coding SQL queries for a PHP app. Suddenly, using the database went from being a tedious chore, to being easy and - dare I say - fun. ...then I started to notice the performance issues. ActiveRecord itself wa
Tips for Writing Fast Rails: Part 1 - FastRuby.io | Rails Upgrade Service
Published on October 11, 2016. Updated on March 5, 2020. Rails opens a new window is a powerful framework. You can write a lot of features in a short period of time. In the process you can easily write code that performs poorly. At OmbuLabs opens a new window we like to maintain Ruby on Rails applications opens a new window . In the process of maintaining them, adding features and fixing bugs, we
Advanced Postgres Performance Tips
You’ve added the INDEXes, both partial and covering. You’ve VACCUUM ANALYZEd. You JOINed and INNER JOINed everything to a single query. And yet, your report is still taking too long. What do you do when the low-hanging fruit has been harvested? It’s time to get down and dirty with some of the lesser known SQL constructs in Rails land. EXPLAIN what’s happening If you’ve gotten this far, you’re prob
Speeding Up Bulk Imports in Rails
This article is about speeding up bulk imports in Rails. Let's imagine we have 50,000 products to import... not an absurd amount, but enough that we can start to notice some pain and enough that we wouldn't want to keep the user sitting there while the system tries to import them all. That is unless we can figure out a way to have these records imported quickly. The Data We're Working WithWe'll be
RailsエンジニアのためのSQLチューニング速習会 (2015/12/10 19:30〜)
概要 Wantedlyが内部向けにやっている勉強会に15名様だけご招待。 今回は、Web エンジニアによる SQL のチューニング方法速習会を行います。 DB としては PostgreSQL を使います。また、Wantedly は Rails での開発を行っている為、ActiveRecord の利用を前提とします。 SQL の書き方や index の貼り方によって、PostgreSQL 内部での処理がどう変わって、どうパフォーマンスに影響するのかが分かる様になります。 対象 Rails アプリを高速化したい方 スロークエリのチューニング方法を知りたい方 PostgreSQL の JOIN のアルゴリズムや index による高速化の仕組みに興味がある方 この速習会で出来るようになること explainの見方 Indexをはるべきでないケースの見極め ロジックの変更も含めた高速なクエリへの書
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
https://jasacuantop.com/
GitHub - exAspArk/batch-loader: :zap: Powerful tool for avoiding N+1 DB or HTTP queries
PG MatViews for better performance in Rails 🚀
GitHub - basecamp/marginalia: Attach comments to ActiveRecord's SQL queries
Speeding up RSpec and Cucumber on the CI server with PostgreSQL fsync flag and parallel execution - Closer to Code