Postgresql – Efficiently indexing sparse nullable column in Postgres
I need to index a Postgres column that consists of mostly NULL values. I don't want the NULL values to be stored in the index (to make the index smaller, and to speed up row insertion). However, adding a partial…