boomer918

6 ms·

1. 31.▲
   by boomer918 6y ago

   Me too. Why do I have to choose?
2. 32.▲
   by boomer918 6y ago

   Why would ever you use anything else.
3. 33.▲
   by boomer918 6y ago

   Partial indexes can flip query plans if the covered part becomes so small that it won't be represented when sampled by the stats collector. The planner could then decide that the index scan isn't worth it and could try an alternat
4. 34.▲
   by boomer918 6y ago

   Theoretically your argument would make sense, but practically your data distribution should be uniform enough for the statistics collector to work for terabytes and terabytes. I've seen query plans get messed up with partial indexes, b
5. 35.▲
   by boomer918 6y ago

   Some idiomatic suggestions seemed to replace lacking language features, which is a smell to me; I think it's best to use the language as designed instead of creating something weird and maybe even unstable like a "finally" bl