On Mon, Aug 24, 2020 at 4:21 PM iulian dragos <iulian.dra...@databricks.com> 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 >
