Обсуждение: BUG #13461: Error message appears to use incorrect values

Поиск
Список
Период
Сортировка

BUG #13461: Error message appears to use incorrect values

От
martin.kevin@gmail.com
Дата:
The following bug has been logged on the website:

Bug reference:      13461
Logged by:          Kevin Martin
Email address:      martin.kevin@gmail.com
PostgreSQL version: 9.4.1
Operating system:   AWS RDS
Description:

Given a column of 1000-dimension cubes the following triggers an error:
CREATE INDEX ktest ON items USING gist(embeddings);
ERROR:  index row size 8016 exceeds maximum 8152 for index "ktest"

The error message appears to be out of order - the index row size reported
is smaller than the maximum.

Re: BUG #13461: Error message appears to use incorrect values

От
Tom Lane
Дата:
martin.kevin@gmail.com writes:
> The following bug has been logged on the website:
> Bug reference:      13461
> Logged by:          Kevin Martin
> Email address:      martin.kevin@gmail.com
> PostgreSQL version: 9.4.1
> Operating system:   AWS RDS
> Description:

> Given a column of 1000-dimension cubes the following triggers an error:
> CREATE INDEX ktest ON items USING gist(embeddings);
> ERROR:  index row size 8016 exceeds maximum 8152 for index "ktest"

> The error message appears to be out of order - the index row size reported
> is smaller than the maximum.

Hm.  No, the arguments are correctly ordered.  What this looks like is the
criterion to throw the error is overly conservative, or maybe there's some
other logic bug in the page-split code.  Can you supply sample data that
triggers this error?

            regards, tom lane