3 ms·
If you were going to enforce a maximum size so that you could sort on the client, I bet you could just use an integer and rewrite the entire sequence from 1 to
by tshaddox 4y ago
If you were going to enforce a maximum size so that you could sort on the client, I bet you could just use an integer and rewrite the entire sequence from 1 to N on every reorder operation. Unless you were expecting to have way more writes than reads, which is a little hard to imagine.
- eatonphil 4y ago> so that you could sort on the client You could probably also sort in the database with a recursive cte or with PL/pgSQL.
- tshaddox 4y agoIndeed, but AFAIK that is still much slower than sorting on an indexed integer column, which probably means you still need to enforce a maximum list length.