pull down to refresh
Man I was cooking the DB's CPU with an index typo.
CREATE INDEX IF NOT EXISTS some_idx ON some_table(some_value DESC NULLS LAST) is NOT equivalent to CREATE INDEX IF NOT EXISTS some_idx ON some_table(some_value DESC).
CREATE INDEX IF NOT EXISTS some_idx ON some_table(some_value DESC NULLS LAST)
CREATE INDEX IF NOT EXISTS some_idx ON some_table(some_value DESC)
Man I was cooking the DB's CPU with an index typo.
CREATE INDEX IF NOT EXISTS some_idx ON some_table(some_value DESC NULLS LAST)is NOT equivalent toCREATE INDEX IF NOT EXISTS some_idx ON some_table(some_value DESC).