Re: [DOCS] The multi-column index create fail

Поиск
Список
Период
Сортировка
От Pantelis Theodosiou
Тема Re: [DOCS] The multi-column index create fail
Дата
Msg-id CAE3TBxxg=tanArvca=LYfVtvDEJ=C_LYoR7Z_djxow86H452WQ@mail.gmail.com
обсуждение исходный текст
Ответ на [DOCS] The multi-column index create fail  (2512498635@qq.com)
Список pgsql-docs
You need to install the btree_gin extension, with CREATE EXTENSION, in each database that you want such indexes.

See: https://www.postgresql.org/docs/current/static/btree-gin.html
and
https://www.postgresql.org/docs/current/static/sql-createextension.html


On Mon, Nov 6, 2017 at 3:47 AM, <2512498635@qq.com> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/gin-tips.html
Description:

I fail to create  multi-column index use following statements:
create table t_gin3 (id int, c1 int, c2 int, c3 int, c4 int, c5 int, c6 int,
c7 int, c8 int, c9 int);
create index idx_t_gin3_1 on t_gin3 using GIN
(c1,c2,c3,c4,c5,c6,c7,c8,c9);

but the document says gin supports multi-columns

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

В списке pgsql-docs по дате отправления:

Предыдущее
От: 2512498635@qq.com
Дата:
Сообщение: [DOCS] The multi-column index create fail
Следующее
От: Devrim Gündüz
Дата:
Сообщение: [DOCS] [Patch] PDF builds on Red Hat for <= 9.6