Search Postgresql Archives

Index tuple deduplication limitations in pg13

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

 



Hi,

I was reading through the new features of PG13 (beta), and noticed
that deduplication is disabled for float(4, 8) and numeric (and jsonb,
...) due to that the datums of those types could be not binary equal,
but equal according for the opclass used.

But, if the ordering of operator-class equal tuples is already
system-defined, could the physical ordering of index tuples in a btree
(with deduplication enabled for "unsafe" opclasses) be updated from
[index_columns, tid] to [index_columns,
image_compare(non_datum_equal_columns), tid], giving a stable sorting
of opclass-equal and image-equal values and enabling safe consistent
deduplication?

This need not be a default-on feature (opt-in would be fine, as I
guess it could have a performance penalty), but having the ability to
use btree index tuple deduplication for numeric, float and other data
types would count as a win in my book.

-Matthias





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[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]

  Powered by Linux