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: Ozz Nixon <ozznixon@xxxxxxxxx>
Date: Fri, 26 Oct 2018 12:49:45 -0400
Cc: splarv@xxxxx, srkrishna1@xxxxxxx, pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAMkU=1zmsorK4dGtyP0OG3LU_0e56RsKucvka8okyr9-3N4Qxw@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>

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.

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

Follow-Ups:
- RE: GIN Index for low cardinality
  - From: Igor Neyman

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

Prev by Date: Re: GIN Index for low cardinality
Next by Date: Re: Different memory allocation strategy in Postgres 11?
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]