The Benefits of Materialized Views (and how to use them in your Ruby on Rails project)
When I first heard about materialized views, my mind was kind of blown. “So, I can write a SQL query and the results can be stored as its own table (and live on disk?)”. If that puppy lives in-memory, it’s GOT TO BE faster then having to dig into the deep, dark depths of the database. Right? Yeah, it’s true. Grabbing data from disk, just sitting there, ready for you, is pretty fast. But when is it
Scaling the GitLab database | GitLab
For a long time GitLab.com used a single PostgreSQL database server and a single replica for disaster recovery purposes. This worked reasonably well for the first few years of GitLab.com's existence, but over time we began seeing more and more problems with this setup. In this article we'll take a look at what we did to help solve these problems for both GitLab.com and self-managed GitLab instance
How I Reduced my DB Server Load by 80%
❶ Author of How to Open Source (.dev). A book to take you from coder to contributor. ❷ Creator of CodeTriage, a free service helping developers contribute to open source. ❸ Core committer to ruby/ruby. ❹ Rust Cloud Native Buildpack author . ❺ Married to Ruby, literally. Database load can be a silent performance killer. I’ve been optimizing the query performance of a web app I run designed to get p
Postgres tips for Rails developers
Postgres tips for Rails developers Written by Lukas Fittl April 28, 2017 This week at RailsConf, we found ourselves sharing a lot of tips for using PostgreSQL with Rails. We thought it might be worthwhile to write up many of these and share more broadly. Here you’ll find some tips that will help you in debugging and improving performance of your database from your Rails app. And now, on to the cod
RubyLetter - A Rubyist's Guide to Postgresql's Explain
If you want to understand why your database queries maybe aren’t as fast as they used to be, nothing beats a little feature of postgres called explain . It’s a simple idea. Just ask postgres to explain how it plans to perform a query and it’ll tell you. You can even have it execute the query it and compare expected performance to actual. Sound familiar? You may have seen explain before. Ever sinc
Simple tips to make scaling your database easier as you grow
Simple tips to make scaling your database easier as you grow By Starr Horne on Feb 6, 2017 When you're working on a young project you're constantly making decisions that will make it either easier or harder to scale later. Sometimes it's good to pick the short-term gain, to accrue a bit of technical debt so you can ship faster. But other times we pick up technical debt because we didn't know there
Zero Downtime Migrations with ActiveRecord and PostgreSQL
Photo by bioxzersAs our database and traffic continued to grow, we discovered that certain migrations which appeared harmless actually caused table locking and, in some cases, downtime! Instead of requiring all of our engineers to remember each one of these special cases, we’ve decided to automatically audit migrations at development and test time using the zero_downtime_migrations gem. This gem d
Zero-downtime Postgres migrations - a little help
We're pleased to announce the release of ActiveRecord::SaferMigrations, a library to make changing the schema of Postgres databases safer. Interested how? Read on. Previously, we looked at how seemingly safe schema changes in Postgres can take your site down. We ended that article with some advice, and today we want to make that advice a little easier to follow. A recapIn a nutshell, there are som
DBのViewを作ったらRailsプログラムが綺麗になった話 | 自転車で通勤しましょ♪ブログ
最近データベースというかSQLについて勉強しているんですが、奥が深いですね。この前の第9回中国地方DB勉強会のときに聞いたrank関数を使って、ランキング機能をリファクタリングしよう！と思って最近頑張ってます。というのも、複雑なクエリ（遅い）を業種数分（10回くらい）呼んでいたため、Herokuだと結構ギリギリの速度になることもあったので、なんとかしなければ！と思っていたのです。 とりあえず、私の開発環境を載せておきます。 Mac Yosemite Ruby 2.2 Rails 4.2.1 PostgreSQL 9.3.4 ひとまずrank関数を使うところまで まず、NewRelicを使ってActiveRecordが出力しているSQLを取得し、それを0xDBEのコンソールに貼り付けて、rank関数を使って業種でパーティションしてランキングを出すところまでしてみました。rank関数は、関数名
Sorting an ActiveRecord relation by PostgreSQL hstore value with Arel
How to use Arel in Rails in order to sort by a PostgreSQL hstore valueFor the past 2 days I was struggling with sorting an ActiveRecord relation by a value in a hstore hash. I currently work on a project that is a product catalog. Every attribute of the Product model had to be translated into multiple languages. So I picked the hstore_translations gem. In a nutshell the gem stores translations of
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
GitHub - crashtech/torque-postgresql: Add support to advanced resources of PostgreSQL, like data types, array associations, and auxiliary statements (CTE)
Postgres enums with Rails
GitHub - rkrage/pg_party: ActiveRecord PostgreSQL Partitioning
DailyDrip.com is For Sale | BrandBucket
GitHub - LendingHome/zero_downtime_migrations: Zero downtime migrations with ActiveRecord 3+ and PostgreSQL
Using PostgreSQL UUIDs as primary keys with Rails 5 – Fabiano Leite
GitHub - pacuna/partitionable: Seamless PostgreSQL date partitioning for your Rails models
GitHub - gocardless/activerecord-safer_migrations: Safer ActiveRecord migrations for Postgres
Post by @y-yagi
Post by @y-yagi