diff options
| author | Nathan Bossart <nathan@postgresql.org> | 2024-03-14 10:58:00 -0500 |
|---|---|---|
| committer | Nathan Bossart <nathan@postgresql.org> | 2024-03-14 10:58:00 -0500 |
| commit | d1162cfda885c5a8cb9cebfc8eed9f1d76855e83 (patch) | |
| tree | 7211679289e248d36e3129aa19f6518ac53ec584 /doc/src | |
| parent | 84c18acaf690e438e953e387caf1c13298d4ecb4 (diff) | |
| download | postgresql-d1162cfda885c5a8cb9cebfc8eed9f1d76855e83.tar.gz postgresql-d1162cfda885c5a8cb9cebfc8eed9f1d76855e83.zip | |
Add pg_column_toast_chunk_id().
This function returns the chunk_id of an on-disk TOASTed value. If
the value is un-TOASTed or not on-disk, it returns NULL. This is
useful for identifying which values are actually TOASTed and for
investigating "unexpected chunk number" errors.
Bumps catversion.
Author: Yugo Nagata
Reviewed-by: Jian He
Discussion: https://postgr.es/m/20230329105507.d764497456eeac1ca491b5bd%40sraoss.co.jp
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 91f1e693594..72c5175e3b3 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -28555,6 +28555,23 @@ postgres=# SELECT '0/0'::pg_lsn + pd.segment_number * ps.setting::int + :offset <row> <entry role="func_table_entry"><para role="func_signature"> <indexterm> + <primary>pg_column_toast_chunk_id</primary> + </indexterm> + <function>pg_column_toast_chunk_id</function> ( <type>"any"</type> ) + <returnvalue>oid</returnvalue> + </para> + <para> + Shows the <structfield>chunk_id</structfield> of an on-disk + <acronym>TOAST</acronym>ed value. Returns <literal>NULL</literal> + if the value is un-<acronym>TOAST</acronym>ed or not on-disk. See + <xref linkend="storage-toast"/> for more information about + <acronym>TOAST</acronym>. + </para></entry> + </row> + + <row> + <entry role="func_table_entry"><para role="func_signature"> + <indexterm> <primary>pg_database_size</primary> </indexterm> <function>pg_database_size</function> ( <type>name</type> ) |