3 ms·
1. Yeah, the reason for that is that by default a GIN index doesn't support greater than or less than operators. However, you can introduce btree like functiona
by chris_wot 11y ago
1. Yeah, the reason for that is that by default a GIN index doesn't support greater than or less than operators. However, you can introduce btree like functionality by using btree_gin and I believe it should start working.
2. That's (probably) occurring because the default statistics target is 100. Just increase them with:
ALTER TABLE gin_index ALTER COLUMN indexed_column SET STATISTICS 1000;
That should hopefully help with all the other issues you are seeing.
P.S. while looking at MongoDB a little further, I discovered that it doesn't support sorting by collation. This was logged as a JIRA bug in 2014, and as of yet I don't believe there is a solution.
https://jira.mongodb.org/browse/SERVER-1920 https://jira.mongodb.org/browse/SERVER-1920