Re: GIN Index for low cardinality

From: Ozz Nixon <ozznixon(at)gmail(dot)com>
To: jeff(dot)janes(at)gmail(dot)com
Cc: splarv(at)ya(dot)ru, srkrishna1(at)aol(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: GIN Index for low cardinality
Date: 2018-10-26 16:49:45
Message-ID: CA+knxPoUT2Yzttz2ksnMYQWrPAEb9osnKceMz3oR8jSh0_H+mw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2018-10-26 17:10:34 Re: Different memory allocation strategy in Postgres 11?
Previous Message Jeff Janes 2018-10-26 16:27:21 Re: GIN Index for low cardinality