Hello!

Yes, it will have global impact on all indexes on primary keys, and all
indexes created without INLINE SIZE clause.

Regards,
-- 
Ilya Kasnacheev


чт, 14 мая 2020 г. в 16:53, 38797715 <[email protected]>:

> Hi,
>
> I see this property.
> If this property is configured, it has a global impact? What is the
> influence range of this parameter?
> 在 2020/5/14 下午9:41, Stephen Darlington 写道:
>
> Exactly as the warning says, with the IGNITE_MAX_INDEX_PAYLOAD_SIZE
> property:
>
> ./ignite.sh -J-DIGNITE_MAX_INDEX_PAYLOAD_SIZE=33
>
> Regards,
> Stephen
>
> On 14 May 2020, at 14:23, 38797715 <[email protected]> wrote:
>
> Hi,
>
> Today, I see the following information in the log:
> [2020-05-14T16:42:04,346][WARN][query-#7759][IgniteH2Indexing] Indexed
> columns of a row cannot be fully inlined into index what may lead to
> slowdown due to additional data page reads, increase index inline size if
> needed (set system property IGNITE_MAX_INDEX_PAYLOAD_SIZE with recommended
> size (be aware it will be used by default for all indexes without
> explicit inline size)) [cacheName=NEW, tableName=NEW, idxName=_key_PK,
> idxCols=(CO_NUM, CUST_ID), idxType=PRIMARY KEY, curSize=10, recommendedInl
> ineSize=33]
>
> I know that the create index statement has an inline_ size clause, but I
> want to ask, how to adjust the inline size of primary key?
>
>
>
>

Reply via email to