4 ms·
seq_page_cost is 1; random_page_cost is 2; I have many other problems with the planner, this is the most absurd due to the simplicity of the query.
by zac23or 3y ago
seq_page_cost is 1;
random_page_cost is 2;
I have many other problems with the planner, this is the most absurd due to the simplicity of the query.
- zacmps 3y agoOn an SSD I'd drop random to 1-1.2.
- franckpachot 3y agoIf changing random_page_cost from 4 to 2 makes a difference, then probably there are no good indexes. The choice between Seq Scan and Index Scan should be obvious without depending on small adjustments or one day, with slightly different data distribution the plan will flip to a bad one