diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 9 | ||||
| -rw-r--r-- | doc/src/sgml/pageinspect.sgml | 22 |
2 files changed, 15 insertions, 16 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index d7a73767984..b5718fc1366 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -8529,11 +8529,10 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; <para> If no tuples were deleted from the heap, B-tree indexes are still - scanned at the <command>VACUUM</command> cleanup stage when at least one - of the following conditions is met: the index statistics are stale, or - the index contains deleted pages that can be recycled during cleanup. - Index statistics are considered to be stale if the number of newly - inserted tuples exceeds the <varname>vacuum_cleanup_index_scale_factor</varname> + scanned at the <command>VACUUM</command> cleanup stage when the + index's statistics are stale. Index statistics are considered + stale if the number of newly inserted tuples exceeds the + <varname>vacuum_cleanup_index_scale_factor</varname> fraction of the total number of heap tuples detected by the previous statistics collection. The total number of heap tuples is stored in the index meta-page. Note that the meta-page does not include this data diff --git a/doc/src/sgml/pageinspect.sgml b/doc/src/sgml/pageinspect.sgml index e29eb0783ab..59620faec00 100644 --- a/doc/src/sgml/pageinspect.sgml +++ b/doc/src/sgml/pageinspect.sgml @@ -298,16 +298,16 @@ test=# SELECT t_ctid, raw_flags, combined_flags index's metapage. For example: <screen> test=# SELECT * FROM bt_metap('pg_cast_oid_index'); --[ RECORD 1 ]-----------+------- -magic | 340322 -version | 4 -root | 1 -level | 0 -fastroot | 1 -fastlevel | 0 -oldest_xact | 582 -last_cleanup_num_tuples | 1000 -allequalimage | f +-[ RECORD 1 ]-------------+------- +magic | 340322 +version | 4 +root | 1 +level | 0 +fastroot | 1 +fastlevel | 0 +last_cleanup_num_delpages | 0 +last_cleanup_num_tuples | 230 +allequalimage | f </screen> </para> </listitem> @@ -337,7 +337,7 @@ page_size | 8192 free_size | 3668 btpo_prev | 0 btpo_next | 0 -btpo | 0 +btpo_level | 0 btpo_flags | 3 </screen> </para> |