Postgresql – Change to Postgres indexing scheme for IS NOT NULL?
I have a Postgres table that has numerous columns which frequently show up in the where clause of select queries. The table has been indexed accordingly, with indexes on all of these columns (mostly single-column indexes, but with some composite…