when row
estimate is way higher then on idx_route_02? Wouldn't it be better just to
use one index with lower number of estimated rows and then filter?
Thanks
Sasa
On 20 June 2018 at 16:53, Jeff Janes wrote:
> On Wed, Jun 20, 2018 at 9:21 AM, Sasa Vilic wrote:
>
>
>> Query t
Regarding test server, I believe that it is a SSD, but I will get
confirmation for this. I tried changing random_page_cost on test server
from 2.0 to 1.0 (that should be right value for SSD, right?) and also to
4.0 and I get same results.
Regards
Sasa Vilic
On 20 June 2018 at 15:29, Matthew H
|
| |
0.607223332 |point |fir |281 |62
|101|
0.0247033276 |point |navaidfrequency |744 |100
|101|
0.032087 |point |elevation |14013|100
|101|
0.001145 |point |magneticvariance|-0.587834716 |100
|101|
0.978270054 |point |startvalid |35 |12
|23 |
0.978176594 |point |endvalid|30 |11
|19 |
0.978123426 |point |revisionuid |62 |12
|50 |
0.9994|point |source |3|3
| |
0.777056634 |point |leveltype |7|7
| |
I am looking forward to your suggestions.
Thanks in advance!
Sasa Vilic
