title: Why RDS with Postgres performance issues, while fetching data?
body: <p>In Rails web application there is big performance problem issue on RDS compared to Digital Ocean:</p>
  
  <p><strong>Application Configuration:</strong></p>
  
  <pre><code>Ruby 1.9.3 
  Rails 3
  PostgreSQL 9.3
  </code></pre>
  
  <p>I have database which is having records approx 500 million. All data is well indexed and optimized. When I am selecting of the data from heavy tables in database, same query is taking <strong>5-10 mins</strong> approx on "digital ocean" and <strong>65-70 mins</strong> on Amazon RDS server.</p>
  
  <p>I am having existing server with configuration below:</p>
  
  <p><strong>Server Configuration:</strong></p>
  
  <pre><code>Hosted on server: Digital Ocean
  Storage: 1 TB
  RAM: 96 GB
  Processor: 24 core
  </code></pre>
  
  <p>The above configuration is cost expensive with "Digital Ocean". So I created new server on Amazon with RDS.</p>
  
  <p>So please help. </p>
  
  <p>Why <strong>Amazon RDS for PostresSql causing this much of big time difference</strong> in DB operations.</p>
  
  <p>Thanks in advance.</p>