pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgsql: pageinspect: Fix gist_page_items() with included columns
3+ messages / 1 participants
[nested] [flat]

* pgsql: pageinspect: Fix gist_page_items() with included columns
@ 2023-05-19 03:39  Michael Paquier <michael@paquier.xyz>
  0 siblings, 0 replies; 3+ messages in thread

From: Michael Paquier @ 2023-05-19 03:39 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pageinspect: Fix gist_page_items() with included columns

Non-leaf pages of GiST indexes contain key attributes, leaf pages
contain both key and non-key attributes, and gist_page_items() ignored
the handling of non-key attributes.  This caused a few problems when
using gist_page_items() on a GiST index with INCLUDE:
- On a non-leaf page, the function would crash.
- On a leaf page, the function would work, but miss to display all the
values for included attributes.

This commit fixes gist_page_items() to handle such cases in a more
appropriate way, and now displays the values of key and non-key
attributes for each item separately in a style consistent with what
ruleutils.c would generate for the attribute list, depending on the page
type dealt with.  In a way similar to how a record is displayed, values
would be double-quoted for key or non-key attributes if required.

ruleutils.c did not provide a routine able to control if non-key
attributes should be displayed, so an extended() routine for index
definitions is added to work around the leaf and non-leaf page
differences.

While on it, this commit fixes a third problem related to the amount of
data reported for key attributes.  The code originally relied on
BuildIndexValueDescription() (used for error reports on constraints)
that would not print all the data stored in the index but the index
opclass's input type, so this limited the amount of information
available.  This switch makes gist_page_items() much cheaper as there is
no need to run ACL checks for each item printed, which is not an issue
anyway as superuser rights are required to execute the functions of
pageinspect.  Opclasses whose data cannot be displayed can rely on
gist_page_items_bytea().

The documentation of this function was slightly incorrect for the
output results generated on HEAD and v15, so adjust it on these
branches.

Author: Alexander Lakhin, Michael Paquier
Discussion: https://postgr.es/m/17884-cb8c326522977acb@postgresql.org
Backpatch-through: 14

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/e7bff46e50b85c6b37723426188498dab973806c

Modified Files
--------------
contrib/pageinspect/expected/gist.out |  53 +++++++++++++-----
contrib/pageinspect/gistfuncs.c       | 102 ++++++++++++++++++++++++++++++++--
contrib/pageinspect/sql/gist.sql      |  14 +++++
doc/src/sgml/pageinspect.sgml         |  19 +++----
src/backend/utils/adt/ruleutils.c     |  16 ++++++
src/include/utils/ruleutils.h         |   5 ++
6 files changed, 178 insertions(+), 31 deletions(-)



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* pgsql: pageinspect: Fix gist_page_items() with included columns
@ 2023-05-19 03:39  Michael Paquier <michael@paquier.xyz>
  0 siblings, 0 replies; 3+ messages in thread

From: Michael Paquier @ 2023-05-19 03:39 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pageinspect: Fix gist_page_items() with included columns

Non-leaf pages of GiST indexes contain key attributes, leaf pages
contain both key and non-key attributes, and gist_page_items() ignored
the handling of non-key attributes.  This caused a few problems when
using gist_page_items() on a GiST index with INCLUDE:
- On a non-leaf page, the function would crash.
- On a leaf page, the function would work, but miss to display all the
values for included attributes.

This commit fixes gist_page_items() to handle such cases in a more
appropriate way, and now displays the values of key and non-key
attributes for each item separately in a style consistent with what
ruleutils.c would generate for the attribute list, depending on the page
type dealt with.  In a way similar to how a record is displayed, values
would be double-quoted for key or non-key attributes if required.

ruleutils.c did not provide a routine able to control if non-key
attributes should be displayed, so an extended() routine for index
definitions is added to work around the leaf and non-leaf page
differences.

While on it, this commit fixes a third problem related to the amount of
data reported for key attributes.  The code originally relied on
BuildIndexValueDescription() (used for error reports on constraints)
that would not print all the data stored in the index but the index
opclass's input type, so this limited the amount of information
available.  This switch makes gist_page_items() much cheaper as there is
no need to run ACL checks for each item printed, which is not an issue
anyway as superuser rights are required to execute the functions of
pageinspect.  Opclasses whose data cannot be displayed can rely on
gist_page_items_bytea().

The documentation of this function was slightly incorrect for the
output results generated on HEAD and v15, so adjust it on these
branches.

Author: Alexander Lakhin, Michael Paquier
Discussion: https://postgr.es/m/17884-cb8c326522977acb@postgresql.org
Backpatch-through: 14

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/2dd77822178807f3da988e1d873777685d9f7504

Modified Files
--------------
contrib/pageinspect/expected/gist.out |  53 +++++++++++++-----
contrib/pageinspect/gistfuncs.c       | 102 ++++++++++++++++++++++++++++++++--
contrib/pageinspect/sql/gist.sql      |  14 +++++
doc/src/sgml/pageinspect.sgml         |  19 +++----
src/backend/utils/adt/ruleutils.c     |  16 ++++++
src/include/utils/ruleutils.h         |   5 ++
6 files changed, 178 insertions(+), 31 deletions(-)



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* pgsql: pageinspect: Fix gist_page_items() with included columns
@ 2023-05-19 03:39  Michael Paquier <michael@paquier.xyz>
  0 siblings, 0 replies; 3+ messages in thread

From: Michael Paquier @ 2023-05-19 03:39 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

pageinspect: Fix gist_page_items() with included columns

Non-leaf pages of GiST indexes contain key attributes, leaf pages
contain both key and non-key attributes, and gist_page_items() ignored
the handling of non-key attributes.  This caused a few problems when
using gist_page_items() on a GiST index with INCLUDE:
- On a non-leaf page, the function would crash.
- On a leaf page, the function would work, but miss to display all the
values for included attributes.

This commit fixes gist_page_items() to handle such cases in a more
appropriate way, and now displays the values of key and non-key
attributes for each item separately in a style consistent with what
ruleutils.c would generate for the attribute list, depending on the page
type dealt with.  In a way similar to how a record is displayed, values
would be double-quoted for key or non-key attributes if required.

ruleutils.c did not provide a routine able to control if non-key
attributes should be displayed, so an extended() routine for index
definitions is added to work around the leaf and non-leaf page
differences.

While on it, this commit fixes a third problem related to the amount of
data reported for key attributes.  The code originally relied on
BuildIndexValueDescription() (used for error reports on constraints)
that would not print all the data stored in the index but the index
opclass's input type, so this limited the amount of information
available.  This switch makes gist_page_items() much cheaper as there is
no need to run ACL checks for each item printed, which is not an issue
anyway as superuser rights are required to execute the functions of
pageinspect.  Opclasses whose data cannot be displayed can rely on
gist_page_items_bytea().

The documentation of this function was slightly incorrect for the
output results generated on HEAD and v15, so adjust it on these
branches.

Author: Alexander Lakhin, Michael Paquier
Discussion: https://postgr.es/m/17884-cb8c326522977acb@postgresql.org
Backpatch-through: 14

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/e72580232c8e61e65af124fb0780c50918eee54c

Modified Files
--------------
contrib/pageinspect/expected/gist.out |  55 ++++++++++++------
contrib/pageinspect/gistfuncs.c       | 104 +++++++++++++++++++++++++++++++---
contrib/pageinspect/sql/gist.sql      |  14 +++++
doc/src/sgml/pageinspect.sgml         |  18 +++---
src/backend/utils/adt/ruleutils.c     |  16 ++++++
src/include/utils/ruleutils.h         |   5 ++
6 files changed, 180 insertions(+), 32 deletions(-)



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2023-05-19 03:39 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-19 03:39 pgsql: pageinspect: Fix gist_page_items() with included columns Michael Paquier <michael@paquier.xyz>
2023-05-19 03:39 pgsql: pageinspect: Fix gist_page_items() with included columns Michael Paquier <michael@paquier.xyz>
2023-05-19 03:39 pgsql: pageinspect: Fix gist_page_items() with included columns Michael Paquier <michael@paquier.xyz>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox