RE: GIN Index for low cardinality
От
Igor Neyman
Тема
RE: GIN Index for low cardinality
Дата
Msg-id
DM5PR17MB153244B2A898D6FFABAE624EDAF00@DM5PR17MB1532.namprd17.prod.outlook.com
Ответ на
Re: GIN Index for low cardinality (Ozz Nixon)
Список
Дерево обсуждения
Problem creating a database Joshua White <joshua.white@monash.edu>
Re: Problem creating a database Colin Coles <mailinglists@beachcentral.co.uk>
Re: Problem creating a database Joshua White <joshua.white@monash.edu>
Re: Problem creating a database Ben Madin <ben@ausvet.com.au>
Re: Problem creating a database Joshua White <joshua.white@monash.edu>
Re: Problem creating a database Laurenz Albe <laurenz.albe@cybertec.at>
Re: Problem creating a database Joshua White <joshua.white@monash.edu>
Re: Problem creating a database Laurenz Albe <laurenz.albe@cybertec.at>
Re: Problem creating a database Joshua White <joshua.white@monash.edu>
Re: Problem creating a database Joshua White <joshua.white@monash.edu>
Re: Problem creating a database Laurenz Albe <laurenz.albe@cybertec.at>
GIN Index for low cardinality Ravi Krishna <srkrishna1@aol.com>
Re: GIN Index for low cardinality Олег Самойлов <splarv@ya.ru>
Re: GIN Index for low cardinality Ravi Krishna <srkrishna1@aol.com>
Re: GIN Index for low cardinality Jeff Janes <jeff.janes@gmail.com>
Re: GIN Index for low cardinality Олег Самойлов <splarv@ya.ru>
Re: GIN Index for low cardinality Ozz Nixon <ozznixon@gmail.com>
RE: GIN Index for low cardinality Igor Neyman <ineyman@perceptron.com>
Re: GIN Index for low cardinality Jeff Janes <jeff.janes@gmail.com>
Re: GIN Index for low cardinality Jeff Janes <jeff.janes@gmail.com>
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 по дате отправления
От: Thomas Kellerer
Дата:
