Re: GIN Index for low cardinality

From: Ravi Krishna <srkrishna1(at)aol(dot)com>
To: splarv(at)ya(dot)ru
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: GIN Index for low cardinality
Date: 2018-10-25 13:55:58
Message-ID: 1521513486.16082500.1540475758494@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>Does it mean that GIN is a very good choice for low cardinality columns.  
>Not necessary. There is other index which also don’t keep column value in an every leaf. Hash, for instance. 

Well I asked about GIN's usefulness for low cardinality. Good to know that Hash can also be considered.
BTW until recently wasn't Hash unsafe for production since it was not WAL logged.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pratik Parikh 2018-10-25 14:03:14 Re: Compile and build portable postgresql for mac
Previous Message Олег Самойлов 2018-10-25 13:36:13 Re: GIN Index for low cardinality