On Mon, Jan 11, 2021 at 9:52 AM Rémi Chatenay <remi.chate...@doctolib.com> wrote:
> I'd say it's a 1 insert for 5 - 10 updates. > > As for the index on the status, it's because we have a job that runs every > night that deals with conversations in specific statuses. Having a low > cardinality index that changes frequently seems prone to mis-use by the > system. -> What would be an alternative ? > One option would be a partial index on another field used in that query *where status in ( list_of_uncommon_statuses_queried_nightly )* Sequential scan may be perfectly fine for a nightly script though.
