On Mon, Aug 24, 2020 at 4:21 PM iulian dragos <iulian.dragos@xxxxxxxxxxxxxx> wrote:
Hi Michael,Thanks for the answer. It's an RDS instance using SSD storage and the default `random_page_cost` set to 4.0. I don't expect a lot of repetitive queries here, so I think caching may not be extremely useful. I wonder if the selectivity of the query is wrongly estimated (out of 500 million rows, only a few thousands are returned).I tried lowering the `random_page_cost` to 1.2 and it didn't make a difference in the query plan.
I experimented a bit more with different values for this setting. The only way I could make it use the index was to use a value strictly less than `seq_page_cost` (0.8 for instance). That doesn't sound right, though.
The size of the effective_cache_size is fairly high as well (32 GB) for an instance with 64GB (db.m5.4xlarge).
iulian
