We are looking at 4 methods: Insert One Record at a Time, Bulk Inserts with Active Record Import, PostgreSQL Copy with Activerecord-copy, Using Background Jobs.| pganalyze
We share how views differ from materialized views and show how using Postgres views makes querying aggregated data easier and (with materialized views) faster.| pganalyze
Active Record lets you access raw SQL. We look at 5 business requests for data, translate them into SQL, then into Rails code to find the requested data.| pganalyze
This article shows how to optimize a Full Text Search implementation with Rails and PostgreSQL, taking a single query from 130ms to 7ms.| pganalyze