From: Ozz Nixon <ozznixon@gmail.com> Sent: Friday, October 26, 2018 12:50 PM To: jeff.janes@gmail.com Cc: splarv@ya.ru; srkrishna1@aol.com; pgsql-general@lists.postgresql.org Subject: Re: GIN Index for low cardinality
Jeff,
Great info! Your example on Mr. Mrs. Miss, etc. is there a good rule of thumb that if the data is under "x"KB an index is overhead not help? I am not worried about space, more interested in performance.
I think, partial/conditional indexes: …. Where greeting = ‘…’ – may help.