Search Postgresql Archives

RE: GIN Index for low cardinality

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: RE: GIN Index for low cardinality
From: Igor Neyman <ineyman@xxxxxxxxxxxxxx>
Date: Fri, 26 Oct 2018 17:21:49 +0000
Accept-language: en-US
Cc: "splarv@xxxxx" <splarv@xxxxx>, "srkrishna1@xxxxxxx" <srkrishna1@xxxxxxx>, "pgsql-general@xxxxxxxxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CA+knxPoUT2Yzttz2ksnMYQWrPAEb9osnKceMz3oR8jSh0_H+mw@mail.gmail.com>
References: <CAGY1NOkYep1Mshow9aZe6wM1YipTYuL09MpR0QHDjcqbOxm0Jg@mail.gmail.com> <cedd5ae45b99b0f4fd9b75319700bbc8cf431eec.camel@cybertec.at> <CAGY1NOk=MFvgyjQErd3TR_+FAAOn2O0MNR_q=6udd+L-KU+VHw@mail.gmail.com> <6f6b9febf25df823552b0d80c5eff9eeccf628d4.camel@cybertec.at> <CAGY1NOmpFXV_1L1DFknOh-c-mVfjH6aOfZO_E92iprN-4E87sg@mail.gmail.com> <CAGY1NO=s6qMJtv-yTqoGM8hCAKTsojKdueJSk2AW+HsnDXtKOg@mail.gmail.com> <E260AEE7-95B3-4142-9A4B-A4416F1701F0@aol.com> <3E50E972-7451-4B86-95EF-33A9C2B777FB@ya.ru> <CAMkU=1zmsorK4dGtyP0OG3LU_0e56RsKucvka8okyr9-3N4Qxw@mail.gmail.com> <CA+knxPoUT2Yzttz2ksnMYQWrPAEb9osnKceMz3oR8jSh0_H+mw@mail.gmail.com>

From: Ozz Nixon <ozznixon@xxxxxxxxx>
Sent: Friday, October 26, 2018 12:50 PM
To: jeff.janes@xxxxxxxxx
Cc: splarv@xxxxx; srkrishna1@xxxxxxx; pgsql-general@xxxxxxxxxxxxxxxxxxxx
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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Problem creating a database
  - From: Joshua White
- Re: Problem creating a database
  - From: Laurenz Albe
- Re: Problem creating a database
  - From: Joshua White
- Re: Problem creating a database
  - From: Laurenz Albe
- Re: Problem creating a database
  - From: Joshua White
- Re: Problem creating a database
  - From: Joshua White
- GIN Index for low cardinality
  - From: Ravi Krishna
- Re: GIN Index for low cardinality
  - From: Олег Самойлов
- Re: GIN Index for low cardinality
  - From: Jeff Janes
- Re: GIN Index for low cardinality
  - From: Ozz Nixon

Prev by Date: Re: Different memory allocation strategy in Postgres 11?
Next by Date: How to get partition info for a partition table?
Previous by thread: Re: GIN Index for low cardinality
Next by thread: Re: GIN Index for low cardinality
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]