Index on integer field in PostgreSQL


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/code-flow.club/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
6 views

There


PTS. big sign that PostgreSQL create a field of type integer + a btree index on the field.
Most of the values in the default field.

What you need


To select rows sorted by the given field.

Questions

  • What default value will run faster NULL or 0?
  • The same, in relation to the character(n) NULL or "?
by | 6 views

2 Answers

0 like 0 dislike
I don't think you will feel the difference in speed between NULL and some value. And, by the way, you can easily check for this simple test.
by
0 like 0 dislike
Asked the same question.
Generate a little data and verify whether the index of the query WHERE IS NULL ( I think 80% NULL will be fine)
If the plan shows the use of the index — so the index contains links to ALL of the NULL values, and, accordingly, there is no difference.
It would be interesting to create a sometimes compact codes for "sparse" values, where the references to NULL values are not stored, but usually in this case make the relationship one-to-one with another table.
by

Related questions

0 like 0 dislike
4 answers
0 like 0 dislike
4 answers
0 like 0 dislike
1 answer
0 like 0 dislike
2 answers
110,608 questions
257,186 answers
0 comments
22,671 users