I have a site with around 150.000 daily page views using a 180Mb postgres database size running on a 800 mb ram db on Heroku.
This site does not do many updates, queries are mostly select that are cached on the page.
SELECT count(*) FROM pg_stat_activity; always show 30 connections to the database (that should correspond to at least one connection active per worker).
By looking into new_relic I see queries to the database seem to be around 10ms but I have the impression that even If the 800 mb may be ram. Those queries could eventually run noticeable faster.
Is there any relationship in this scenario to giving more ram to process the queries faster or it doesn't matter since the db size is below 200mb?