Rails 7 + PostgreSQL: Super slow searching data in a table having 1,2M rows. How do I speed it up?
“<p>I have a database table that having close to 100 columns - 25 columns are STRING, the rest is INT/DECIMAL/BOOL.</p>
<p>This is the query that I am trying to run - the query is generated based on the search criteria users have to filter the data in the table <code>listings</code>:</p>
<pre><code>S”
stackexchange · user984621 · 7/29/2024
Open original →Ruby on Rails - Server Memory Spiking and Users getting logged out
“<p>We have a fairly typical Ruby on Rails 6.1 app with a Redis cache store which we are also using for our session store. We are using Devise and an single-page app with lots of graphql requests.</p>
<p>Recently memory has been gradually increasing on the servers until hitting 95%. We're working on ”
stackexchange · Matt · 5/17/2024
Open original →Slow ActiveRecord query mystery
“<p>This question relates to a Rails API-only application using Searchkick (with Opensearch) and PostgreSQL. Some results are taking a long time to render, and I'm seeing something like this, according to the development log:</p>
<p>Opensearch query time: 10ms.
Postgres query time: 7500ms (it's a &qu”
stackexchange · knirirr · 6/1/2023
Open original →