Postgres Pro
Downloads
Home   >   mailing lists

RE: GIN Index for low cardinality - Mailing list pgsql-general

From Igor Neyman
Subject RE: GIN Index for low cardinality
Date
Msg-id DM5PR17MB153244B2A898D6FFABAE624EDAF00@DM5PR17MB1532.namprd17.prod.outlook.com
Whole thread Raw
In response to Re: GIN Index for low cardinality  (Ozz Nixon <ozznixon@gmail.com>)
List pgsql-general
Tree view

 

 

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.

 

Regards,

Igor Neyman

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Different memory allocation strategy in Postgres 11?
Next
From: Yuxia Qiu
Date:
Subject: How to get partition info for a partition table?